LeetCode_Study_Plan/SQL

1050. Actors and Directors Who Cooperated At Least Three Times mysql

개발하는루루 2022. 10. 4. 11:08

https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/?envType=study-plan&id=sql-i 

 

Actors and Directors Who Cooperated At Least Three Times - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

select actor_id, director_id from actordirector group by 1, 2 having count(timestamp) >= 3;