力扣---高频SQL题---41---602. 好友申请 II ：谁有最多的好友

一、题目

二、代码

# Write your MySQL query statement below

select co1 as id,sum(co2) as num from
(
    select requester_id as co1,count(accepter_id ) as co2 from RequestAccepted 
    group by requester_id 
    union all
    select accepter_id as co1,count(requester_id) as co2 from RequestAccepted
    group by accepter_id
) as table1
group by co1
order by num desc
limit 1

三、运行结果