Actor-Director Pairs
ASKED IN INTERVIEWNetflix
Problem Statement
Netflix production teams analyze successful collaborations to greenlight future projects. A collaboration is defined as an actor and a director working together on a single movie (identified by timestamp).
Your task is to find all pairs of actor_id and director_id that have collaborated at least three times.
Rules:
- The same pair must appear 3 or more times in the dataset.
- Output columns: actor_id, director_id.
- Results must be sorted by actor_id in ascending order. If actor_id is the same, sort by director_id in ascending order.
Tests your understanding of
Grouping, Filtering and Aggregation
Input Tables
ActorDirector
| actor_id(INTEGER) | director_id(INTEGER) | timestamp(INTEGER) |
|---|---|---|
| 1 | 1 | 0 |
| 1 | 1 | 1 |
| 1 | 1 | 2 |
| 1 | 2 | 3 |
| 1 | 2 | 4 |
| 2 | 1 | 5 |
| 2 | 1 | 6 |
| 2 | 1 | 7 |
Actors
| actor_id(INTEGER) | actor_name(VARCHAR) |
|---|---|
| 1 | Leonardo DiCaprio |
| 2 | Robert De Niro |
MovieGenres
| timestamp(INTEGER) | genre(VARCHAR) |
|---|---|
| 0 | Drama |
| 1 | Thriller |
| 2 | Crime |
Expected Output
| actor_id(INTEGER) | director_id(INTEGER) |
|---|---|
| 1 | 1 |
| 2 | 1 |
Tags
EasyASKED IN INTERVIEWGroupingFilteringAggregation
10-15 min
82%