[SQL문제풀기] 복수 국적 메달 수상한 선수 찾기

문제

solvesql.com

https://solvesql.com/problems/multiple-medalist/

SQLite

내가 작성한 정답

select a.name
from records r
join teams t on r.team_id = t.id
join (select id, year from games group by year, id having year >= 2000) g on r.game_id = g.id
join athletes a on r.athlete_id = a.id
where r.medal is not null
group by r.athlete_id
having count(distinct t.id)>= 2
order by 1 asc