Top performing students by major
You’re given the table below showing a list of students, their GPA, and their associated majors:
Using the table, write a SQL query to return the 3 students with highest GPAs in each major (keeping any ties).
You can view/query this table in an interactive SQL fiddle here.
Subscribe to premium account to see the solution.Get premium now