Simple Code using HAVING : Actors and Directors Who Cooperated At Least Three Times
Code\n\n# Write your MySQL query statement below\nSELECT actor_id, director_id\nFROM ActorDirector\nGROUP BY actor_id, director_id\nHAVING COUNT(timestamp) >=3;
# Code\n```\n# Write your MySQL query statement below\nSELECT actor_id, director_id\nFROM ActorDirector\nGROUP BY actor_id, director_id\nHAVING COUNT(timestamp) >=3;\n```
['MySQL']