MySQL Different Solution | With & Row_Number() Functions |
\n# Code\nmysql []\nwith cte as (select *, row_number() over(partition by actor_id, director_id) as r from actordirector)\n\nselect distinct actor_id, director_
\n# Code\n```mysql []\nwith cte as (select *, row_number() over(partition by actor_id, director_id) as r from actordirector)\n\nselect distinct actor_id, director_id from cte where r >= 3\n\n```
['MySQL']