2 MySQL Solutions: GROUP BY & RANK()
1. Using GROUP BY and HAVING clause (the simplest one)\n\nSELECT a.actor_id, a.director_id\nFROM ActorDirector a\nGROUP BY a.actor_id, a.director_id\nHAVING COU
### 1. Using `GROUP BY` and `HAVING` clause (the simplest one)\n```\nSELECT a.actor_id, a.director_id\nFROM ActorDirector a\nGROUP BY a.actor_id, a.director_id\nHAVING COUNT(timestamp) > 2\n```\n\n### 2. Using `RANK() OVER` clause\n```\nSELECT a1.actor_id, a1.director_id\nFROM (\n    SELECT \n        a.actor_id, \n        a.director_id,\n        RANK() OVER (PARTITION BY a.actor_id, a.director_id\n                     ORDER BY a.timestamp) AS \'coop_count\'\n    FROM ActorDirector a) a1\nWHERE a1.coop_count = 3\n```\n\nThanks for reading!\nIf there\'s any error or doubt, do comment. Feedbacks are always appreciated!!
['MySQL']