본문 바로가기
SQL

leetcode 1050. Actors and Directors Who Cooperated At Least Three Times

by 무적김두칠 2022. 7. 26.

1
2
3
4
5
# Write your MySQL query statement below
select actor_id, director_id
from ActorDirector
group by actor_id, director_id
having count(actor_id)>=3
cs
반응형

'SQL' 카테고리의 다른 글

leetcode 1393. Capital Gain/Loss  (0) 2023.01.26
hackerrank Occupations  (0) 2022.11.13
leetcode 1084. Sales Analysis III  (0) 2022.07.18
leetcode 607. Sales Person  (0) 2022.07.18
leetcode 1527. Patients With a Condition  (0) 2022.07.18

댓글