1050. 合作过至少3次的演员和导演(*)
https://leetcode.cn/problems/actors-and-directors-who-cooperated-at-least-three-times/description/
分析:groupby 可以同时对一行数据进行分组(包括多列),并用having来限制groupby中的条件。
select actor_id,director_id
from ActorDirector
group by actor_id,director_id
having count(timestamp)>=3