TIL - 250609(leetcode_1개)

문제1(링크)

SELECT
    id
    , COUNT(DISTINCT fd) num
FROM (
    SELECT
        requester_id id
        , accepter_id fd
    FROM RequestAccepted
    UNION ALL
    SELECT
        accepter_id id
        , requester_id fd
    FROM RequestAccepted
) a
GROUP BY id
ORDER BY num DESC
LIMIT 1