Last updated on August 4th, 2024 at 11:08 pm
This Leetcode problem Actors and Directors Who Cooperated At Least Three Times LeetCode Solution is done in SQL.
List of all LeetCode Solution
Level of Question
Easy
Actors and Directors Who Cooperated At Least Three Times LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
actor_id | int |
director_id | int |
timestamp | int |
ActorDirector
timestamp is the primary key (column with unique values) for this table.
Write a solution to find all the pairs (actor_id, director_id)
where the actor has cooperated with the director at least three times.
Return the result table in any order.
The result format is in the following example.
Example 1:
Input:
actor_id | director_id | timestamp |
1 | 1 | 0 |
1 | 1 | 1 |
1 | 1 | 2 |
1 | 2 | 3 |
1 | 2 | 4 |
2 | 1 | 5 |
2 | 1 | 6 |
ActorDirector table:
Output:
actor_id | director_id |
1 | 1 |
Explanation: The only pair is (1, 1) where they cooperated exactly 3 times.
1. Actors and Directors Who Cooperated At Least Three Times LeetCode Solution MySQL
select actor_id, director_id from ( select actor_id, director_id, count(*) as cnt from ActorDirector group by actor_id, director_id having cnt >= 3 ) as e;
2. Actors and Directors Who Cooperated At Least Three Times LeetCode Solution MySQL (Another approach)
select actor_id, director_id from ActorDirector group by actor_id, director_id having count(*) >= 3;