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

[LeetCode/SQL]

---

📌 1050. Actors and Directors Who Cooperated At Least Three Times

문제

풀이

- 감독과 최소 3번 함께 협업한 배우,감독을 출력하라

방법

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