Click here to see the full article post
The outer select is redundant, can just do
select id, count(1) as num
select requester_id as id from request_accepted
select accepter_id as id from request_accepted
group by 1
order by 2 desc
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.