[SQL문제풀기] Highest Target Under Manager

문제

StrataScratch - Highest Target Under Manager

StrataScratch

https://platform.stratascratch.com/coding/9905-highest-target-under-manager?code_type=7

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select first_name, target
from salesforce_employees
where (target) in (select max(target)
                    from salesforce_employees
                    where manager_id = 13)
    and manager_id = 13