2025-08-02 10:41:17 +0300 MSK

Actors and Directors Who Cooperated At Least Three Times
Tags:

Code

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