1050-actors-and-directors-who-cooperated-at-least-three-times.md

合作过至少三次的演员和导演

mysql实现

select ACTOR_ID, DIRECTOR_ID
from (
select count(`timestamp`) count, ACTOR_ID, DIRECTOR_ID
from ActorDirector
group by actor_id,director_id
) tmp
where count>=3