---
tags: sql, LeetCode
---
# 1050. Actors and Directors Who Cooperated At Least Three Times
(資訊來自於`leetcode 1050`[ Actors and Directors Who Cooperated At Least Three Times](https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/description/?envType=study-plan&id=sql-i))

---
### 至少合作過三次的演員和導演
#### 使用table
timestamp 是這個表的主鍵列。

## 題目說明:
為報告編寫 SQL 查詢，該報告提供(actor_id, director_id)演員與導演至少合作 3 次的配對。

以任意順序返回結果表。

查詢結果格式如下例所示。
### 解題方式：

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

### 解題解析：
對導演及演員使用group by 抓出兩者的總和值是大於等於3的

By. @OtbmOtOMRzCEOxuIjDNc8A