SQL 50 › 索引 › A6 Subqueries 子查询
LC 602好友申请 II :谁有最多的好友Friend Requests II: Who Has the Most Friends 中等
RequestAccepted 表每行是一次通过的好友申请(申请者与接受者);好友数按双方累计,找出好友最多的人及其数量。
思路 申请者、接受者 UNION ALL 成一列,GROUP BY 计数取第一。
SELECT id, COUNT(*) AS num FROM ( SELECT requester_id AS id FROM RequestAccepted UNION ALL SELECT accepter_id AS id FROM RequestAccepted ) T GROUP BY id ORDER BY num DESC LIMIT 1;