SALARIES — Highest earner in each department

Write a query that returns the name, department, and salary (in this column order) of the highest earning professor in each department.

Table schema

CREATE TABLE SALARIES (Professor_Name TEXT, Department TEXT, Salary INT);

Hint (click to show)

Use a correlated subquery per department.

Your SQL query