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

Column Name	Type
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
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.

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;Code language: SQL (Structured Query Language) (sql)

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;Code language: SQL (Structured Query Language) (sql)

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution

Table of Contents

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution MySQL

Actors and Directors Who Cooperated At Least Three Times LeetCode Solution MySQL (Another approach)

Related Posts