[SQL]friend-requests-ii-who-has-the-most-friends

https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends

Friend Requests II: Who Has the Most Friends - LeetCode

with base as (
    select
        requester_id as id
        , count(distinct accepter_id) cnt
    from RequestAccepted
    group by 1
    union all
    select
        accepter_id as id
        , count(distinct requester_id) cnt
    from RequestAccepted
    group by 1
)
, total as (
    select 
        id, sum(cnt) as num
    from base
    group by 1
)
select
    distinct id, num
from total
order by num desc
limit 1