Last updated on January 22nd, 2025 at 11:20 pm

Here, we see the Actors and Directors Who Cooperated At Least Three Times LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Level of Question

Easy

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

1. Problem Statement

Column Name	Type
actor_id	int
director_id	int
timestamp	int

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

Output:

actor_id	director_id
1	1

Explanation: The only pair is (1, 1) where they cooperated exactly 3 times.

2. Code Implementation in Different Languages

2.1 Actors and Directors Who Cooperated At Least Three Times 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.2 Actors and Directors Who Cooperated At Least Three Times MySQL (Another approach)

select 
  actor_id, 
  director_id 
from 
  ActorDirector 
group by 
  actor_id, 
  director_id 
having 
  count(*) >= 3;