Point72AnalystQuantitative 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.
Unlock the Full Solution
Enter your email to get the detailed step-by-step solution to this Point72 interview question, plus access to free interview prep resources.
We'll also send you a free HFT mock interview video.
More Point72 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?
Get All 23+ Point72 Questions with Solutions
Plus 16+ hours of video lectures, resume tailoring, and 1:1 mentorship from quants.
Schedule a Call