[SQL문제풀기 - Advent of SQL 2025 🎅] 올림픽 메달이 있는 배구 선수

문제

solvesql.com

https://solvesql.com/problems/volleyball-players-with-medals/

내가 작성한 정답

MySQL, SQLite

select a.id, a.name, group_concat(r.medal) medals
from records r
join athletes a on a.id = r.athlete_id 
where r.team_id in (select id from teams where team = 'KOR')
  and r.event_id in (select id from events where event = 'Volleyball Women''s Volleyball')
  and r.medal is not null
group by a.id;

PostgreSQL

select a.id, a.name, string_agg(r.medal,',') medals
from records r
join athletes a on a.id = r.athlete_id 
where r.team_id in (select id from teams where team = 'KOR')
  and r.event_id in (select id from events where event = 'Volleyball Women''s Volleyball')
  and r.medal is not null
group by a.id;