1050. Actors and Directors Who Cooperated At Least Three Times

題目敘述

SQL Schema >

Create table If Not Exists ActorDirector (actor_id int, director_id int, timestamp int) Truncate table ActorDirector insert into ActorDirector (actor_id, director_id, timestamp) values ('1', '1', '0') insert into ActorDirector (actor_id, director_id, timestamp) values ('1', '1', '1') insert into ActorDirector (actor_id, director_id, timestamp) values ('1', '1', '2') insert into ActorDirector (actor_id, director_id, timestamp) values ('1', '2', '3') insert into ActorDirector (actor_id, director_id, timestamp) values ('1', '2', '4') insert into ActorDirector (actor_id, director_id, timestamp) values ('2', '1', '5') insert into ActorDirector (actor_id, director_id, timestamp) values ('2', '1', '6')

Table: ActorDirector

+-------------+---------+ | Column Name | Type | +-------------+---------+ | actor_id | int | | director_id | int | | timestamp | int | +-------------+---------+ timestamp is the primary key column for this table.

Write a SQL query for a report that provides 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 query result format is in the following example.

Example 1:

Input: ActorDirector table: +-------------+-------------+-------------+ | 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 | +-------------+-------------+-------------+ Output: +-------------+-------------+ | actor_id | director_id | +-------------+-------------+ | 1 | 1 | +-------------+-------------+ Explanation: The only pair is (1, 1) where they cooperated exactly 3 times.

題目翻譯

解法解析

解法範例

MySQL

# Write your MySQL query statement below
SELECT actor_id,
    director_id
FROM ActorDirector
GROUP BY actor_id,
    director_id
HAVING count(*) >= 3;

LeetCode Solution, Easy, 1050. Actors and Directors Who Cooperated At Least Three Times

Comments

LeetCode Solution

LeetCode Solution, Easy, 182. Duplicate Emails

More from this blog

如何開始入門軟體工程領域 - 名詞解釋（長期更新）

我的 MacBook Pro (Apple Silicon) 設定

ChatGPT 下的發展預想

一些覺得有用的工具蒐藏

LeetCode Solution, Medium, 607. Sales Person

1050. Actors and Directors Who Cooperated At Least Three Times

題目敘述

題目翻譯

解法解析

解法範例

MySQL

Command Palette

Comments

LeetCode Solution

LeetCode Solution, Easy, 182. Duplicate Emails

More from this blog

1050. Actors and Directors Who Cooperated At Least Three Times

題目敘述

題目翻譯

解法解析

解法範例

MySQL