1136. Actors and Directors Who Cooperated At Least Three Times
My accepted SQL solution to LeetCode problem 1136, Actors and Directors Who Cooperated At Least Three Times, running in 356ms.
- Difficulty: Easy
- SQL
- Runtime 356ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 356ms, memory 0.0B, accepted 2025-12-29.
SELECT actor_id, director_id
FROM ActorDirector
GROUP BY actor_id, director_id
HAVING COUNT(*) >= 3