SQL문제풀기

[SQL문제풀기] Highest Target Under Manager

Feb 01, 2026

[SQL문제풀기] Highest Target Under Manager

Contents

문제 내가 작성한 정답

문제

StrataScratch - Highest Target Under Manager

StrataScratch - Highest Target Under Manager

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

Share article

Contents

문제 내가 작성한 정답