LeetCode Actors and Directors Who Cooperated At Least Three Timesを解いてみた

問題

leetcode.com

解いた

SELECT
    A.actor_id,
    A.director_id
FROM (
    SELECT
        actor_id,
        director_id,
        COUNT(timestamp) AS count
    FROM
        ActorDirector
    GROUP BY
        actor_id,
        director_id) A
WHERE
    A.count >= 3;

結果