思路1
SELECT actor_id, director_id
FROM ActorDirector
GROUP BY actor_id, director_id
HAVING COUNT(*) >= 3;
Previous1050_Actors_and_Directors_Who_Cooperated_At_Least_Three_TimesNext1052_Grumpy_Bookstore_Owner
Last updated
Was this helpful?
SELECT actor_id, director_id
FROM ActorDirector
GROUP BY actor_id, director_id
HAVING COUNT(*) >= 3;
Last updated
Was this helpful?