Skip to content

LeetCode Solutions

1050. Actors and Directors Who Cooperated At Least Three Times

walkccc/LeetCode

LeetCode Solutions

walkccc/LeetCode

Home
Style Guide
Topics
Topics
- I. Data Structures
  I. Data Structures
- II. Algorithms
  II. Algorithms
- III. System Design
  III. System Design
  - Database
  - Design
  - Data Stream
  - Iterator
  - Concurrency
  - Shell
- IV. Special Topics
  IV. Special Topics

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

SQL

SELECT actor_id, director_id
FROM ActorDirector
GROUP BY 1, 2
HAVING COUNT(*) >= 3;