LeetCode Medium problam

[IamShiwangi]

602. Friend Requests II: Who Has the Most Friends

[iamAntimPal]

# Write your MySQL query statement below WITH T AS ( SELECT requester_id, accepter_id FROM RequestAccepted UNION ALL SELECT accepter_id, requester_id FROM RequestAccepted ) SELECT requester_id AS id, COUNT(1) AS num FROM T GROUP BY 1 ORDER BY 2 DESC LIMIT 1; 

[IamShiwangi]

THANKYOU