Last updated on October 10th, 2024 at 12:09 am

This Leetcode problem Actors and Directors Who Cooperated At Least Three Times LeetCode Solution is done in SQL.

List of all LeetCode Solution

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

Problem Statement

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:

Output:

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;