sql연습1 Solvesql 풀어본 후기 #####복수 국적 메달 수상한 선수 찾기 난이도: 보통 주제: JOIN 제출 횟수: 1548번 정답 횟수: 446번 정답률: 28.81% 출제자: solvesql ####정답 SELECT distinct athletes.name FROM(SELECT records.athlete_id AS athlete_id_tmp FROM records LEFT JOIN games ON records.game_id = games.id WHERE games.year >= 2000 AND records.medal is not null GROUP BY athlete_id_tmp HAVING count(distinct records.team_id) >= 2) AS records2 INNER JOIN athletes ON at.. 2022. 11. 4. 이전 1 다음