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

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

# List of all 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.

## 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)```
Scroll to Top