Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

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

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

Problem Statement

Column NameType
actor_id int
director_id int
timestamp int
Table: 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
110
111
112
123
124
215
216
ActorDirector table:

Output:

actor_id director_id
11

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;
Scroll to Top