[SQL문제풀기] 조건에 맞는 사원 정보 조회하기

문제

MYSQL

내가 작성한 정답1

select sum(score) score, e.emp_no, e.emp_name, e.position, e.email
from HR_EMPLOYEES e
join HR_GRADE g on e.emp_no = g.emp_no
where year = 2022
group by e.emp_no, e.emp_name, e.position, e.email, g.year
order by score desc
limit 1

내가 작성한 정답 2

with tb as (select sum(score) score, e.emp_no, e.emp_name, e.position, e.email, g.year 
    from HR_EMPLOYEES e
    join HR_GRADE g on e.emp_no = g.emp_no
    group by e.emp_no, e.emp_name, e.position, e.email, g.year) 
select score, emp_no, emp_name, position, email
from tb
where (score,year) = (select max(score) score,year
                     from tb 
                     group by year
                     having year=2022)