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;