Identify Frequent Actor-Director Collaborations in Film Database
Company: Amazon
Role: Business Intelligence Engineer
Category: Data Manipulation (SQL/Python)
Difficulty: Medium
Interview Round: Onsite
FILMOGRAPHY
+-------+---------+------------+
| actor | dir | date |
+-------+---------+------------+
| Tom | Nolan | 2020-01-01 |
| Tom | Nolan | 2021-01-01 |
| Tom | Nolan | 2022-01-01 |
| Amy | Nolan | 2021-07-01 |
+-------+---------+------------+
##### Scenario
Film industry database: find frequent actor–director collaborations
##### Question
Write an SQL query to list each actor–director pair that has worked together at least three times, returning actor, dir, and collaboration_count.
##### Hints
GROUP BY actor, dir; use HAVING COUNT(*) >= 3.
Quick Answer: This question evaluates competency in relational data manipulation and aggregation, specifically the ability to identify repeated actor–director relationships using SQL or Python data tools.