1050. Actors and Directors Who Cooperated At Least Three Times

Actors and Directors Who Cooperated At Least Three Times - LeetCode

Write a SQL query for a report that provides the pairs (actor_id, director_id) where the actor has cooperated with the director at least three times. Return the result table in any order. The query result format is in the following example.

• code

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