Top candidates by college
Suppose your team interviews undergraduate candidates across many different colleges. You are looking to check which candidates scored the highest from each college.
Given the below tables, write a SQL query (using a window function) to show which candidates scored the highest from each college.
Each row represents a unique interview/candidate as well as the candidate's score (an integer from 1-5, with 5 representing the highest possible score).
Subscribe to premium account to see the solution.Get premium now