SQL문제풀기

[SQL문제풀기] Income By Title and Gender

Jan 28, 2026

[SQL문제풀기] Income By Title and Gender

Contents

문제 내가 작성한 정답

문제

StrataScratch - Income By Title and Gender

StrataScratch - Income By Title and Gender

https://platform.stratascratch.com/coding/10077-income-by-title-and-gender?code_type=1

내가 작성한 정답

MySQL, PostgreSQL, Oracle


select employee_title, sex, avg(salary+b) avg_compensation
from sf_employee e
join (select worker_ref_id, sum(bonus) b from sf_bonus group by worker_ref_id) b
on e.id = b.worker_ref_id
group by employee_title, sex

Share article

Contents

문제 내가 작성한 정답