Point72–styleAnalystQuantitative AnalystQuestion #19
A college maintains department information in one table and student information in another table. Write a SQL query to display the number of students by major in descending order.
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 Analyst Questions
How do the estimated beta coefficients and t-statistics change in Ordinary Least Squares (OLS) regression if each sample in the dataset is duplicated?Given an array of dates in string format (e.g., '20050301'), write a function that returns the year and quarter for each date (e.g., '20050301' => '2005Q1').How would you remove an element from a linked list using an iterator?What are the assumptions of linear regression, and what are the differences between linear regression and logistic regression?
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