SQL/LeetCode

[LeetCode] 1050. Actors and Directors Who Cooperated At Least Three Times

yeyeyep 2025. 2. 19. 15:06

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT actor_id, director_id
FROM ActorDirector
GROUP BY actor_id, director_id
HAVING COUNT(*) >= 3