문제
https://solvesql.com/problems/join/
풀이
SELECT B.athlete_id
FROM events A RIGHT JOIN records B
ON A.id = B.event_id
WHERE 1=1
AND A.sport = 'Golf'
GROUP BY 1후기
records 테이블에서 어떤 컬럼을 events 테이블과 join해야 될지 고민이 필요한 문제였다!
LV. 1
https://solvesql.com/problems/join/
SELECT B.athlete_id
FROM events A RIGHT JOIN records B
ON A.id = B.event_id
WHERE 1=1
AND A.sport = 'Golf'
GROUP BY 1records 테이블에서 어떤 컬럼을 events 테이블과 join해야 될지 고민이 필요한 문제였다!