Point72–styleData ScientistData ScientistQuestion #15
Given a table containing names and ages with some duplicate entries, how would you return all duplicate rows using SQL?
Build Your Approach
State the assumptions, try a simple case, then work toward a general solution. Check the result and explain how it changes if an assumption changes.
Try the free diagnostic with worked solutions →Get Free Interview Prep Resources
More Point72–Style Data Scientist Questions
What happens to the F-statistic and t-statistic if you replicate the data in a dataset?Explain bias and variance. Which models tend to have higher bias versus higher variance?Can a tuple or a list be used as a key in a dictionary?What are the assumptions required for linear regression?How much should you be willing to pay to play the following game? You start with $1. You flip a fair coin. If it lands on heads, you double your winnings and flip again. If it lands on tails, the game is over and you collect the money you've won. You continue playing until you land on tails.
Practice the Reasoning Behind the Answer
Bring your target roles and interview timeline to a free quant consult. Discuss your preparation priorities and how Quant Blueprint’s lessons, practice and mock interviews can help.
Book a Free Quant ConsultYour goals · your preparation · your next steps