← Back to companies
[ OK ] Loaded —
[ INFO ]
$ cd
$ ls -lt
01
02
03
04
05
$ ls -lt
01
02
03
04
05
user@intervues:~/$
A company’s executives want to see who earns the most money in each department. A high earner in a department is defined as an employee whose salary is among the top three unique salaries in that department. Write an SQL query that returns every such high earner, showing the department name, employee name, and salary. The result may be returned in any order.