Leetcode Note: MySQL - Actors and Directors Who Cooperated at Least Three Times

Actors and Directors Who Cooperated At Least Three Times - LeetCode
https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/

• MySQL で取り組んだメモ

回答

MY SQL || SOLUTION - LeetCode Discuss
https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/discuss/2645533/MY-SQL-oror-SOLUTION

select actor_id,director_id
from ActorDirector 
group by actor_id,director_id
Having count(timestamp)>=3;