【力扣sql】高频 SQL 50 题（基础版）

602

找出拥有最多的好友的人和他拥有的好友数目。

RequestAccepted 表：

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| requester_id   | int     |
| accepter_id    | int     |
| accept_date    | date    |
+----------------+---------+

select id, count(*) num
from 
(
    select requester_id id
    from requestaccepted
    union all 
    select accepter_id id
    from requestaccepted
) r
group by id
order by num desc
limit 1