image_2022-04-29_17-26-22.png
25.2 KB
#N1050. Actors and Directors Who Cooperated At Least Three Times
problem link
#solution
problem link
#solution
select actor_id, director_id
from (select actor_id, director_id, count(*) as total from actordirector group by actor_id, director_id) as a where total>=3