[SQL문제풀기] Workers With The Highest Salaries

문제

StrataScratch - Workers With The Highest Salaries

StrataScratch

https://platform.stratascratch.com/coding/10353-workers-with-the-highest-salaries?code_type=3

MySQL, ORACLE

내가 작성한 오답

select t.worker_title
from worker w
join title t on w.worker_id = t.worker_ref_id
where w.salary = (select max(salary) from worker);

내가 작성한 정답

with a as (select t.worker_title, w.salary
           from worker w
           join title t on w.worker_id = t.worker_ref_id)
select worker_title
from a 
where salary = (select max(salary) from a);