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

문제

solvesql.com

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

SQLite

내가 작성한 정답

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