Hard
CTE
Top Three Salaries with CTE
Use a CTE to return the three highest-paid employees. Return columns: salary, last_name, first_name, salary_rank. Order results by: salary DESC) AS salary_rank FROM employees) SELECT first_name, last_name, salary, salary_rank FROM ranked WHERE salary_rank <= 3 ORDER BY salary_rank.
Preparing the interactive SQL workspace...