602. Friend Requests II: Who Has Most Friend?

select requester_id id, count(distinct accepter_id) num from
(
SELECT requester_id, accepter_id FROM [request_accepted]
union
SELECT accepter_id, requester_id FROM [request_accepted]
)
group by requester_id
order by count(distinct accepter_id) desc
limit 1;

posted @ 2018-10-22 10:55  ffeng0312  阅读(147)  评论(0)    收藏  举报