inblog logo
|
stupefyee
    SQL문제풀기

    [SQL 문제 풀이] Actors and Directors Who Cooperated At Least Three Times (세 번 이상 협력한 배우와 감독)

    Stupefyee's avatar
    Stupefyee
    May 23, 2025
    [SQL 문제 풀이] Actors and Directors Who Cooperated At Least Three Times (세 번 이상 협력한 배우와 감독)
    Contents
    내가 작성한 쿼리
    Actors and Directors Who Cooperated At Least Three Times - LeetCode
    Can you solve this real interview question? Actors and Directors Who Cooperated At Least Three Times - Table: ActorDirector +-------------+---------+ | Column Name | Type | +-------------+---------+ | actor_id | int | | director_id | int | | timestamp | int | +-------------+---------+ 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: 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.
    Actors and Directors Who Cooperated At Least Three Times - LeetCode
    https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/description/
    Actors and Directors Who Cooperated At Least Three Times - LeetCode
    notion image
    배우가 감독과 최소 세 번 협력한 모든 쌍(배우_아이디, 감독_아이디)을 찾기 위한 해결책을 작성하세요. 결과 테이블을 순서에 상관없이 반환하세요.
     

    내가 작성한 쿼리

    MySQL, Oracle

    SELECT actor_id, director_id FROM ActorDirector GROUP BY actor_id, director_id HAVING COUNT(*) >= 3
    Share article
    Contents
    내가 작성한 쿼리

    stupefyee

    RSS·Powered by Inblog