SQL每日一题(20210107)求出谁拥有最多的好友和他拥有的好友数目

SQL每日一题(20220225)
SQL每日一题(20220629)

SELECT ID, NUM
  FROM (SELECT ID, COUNT(ID) AS NUM
          FROM (SELECT REQUESTER_ID AS ID
                  FROM T0107
                UNION ALL
                SELECT ACCEPTER_ID AS ID
                  FROM T0107) a
         GROUP BY ID
         ORDER BY NUM DESC) a
limit 1

WITH A AS (SELECT X.REQUESTER_ID, COUNT(X.REQUESTER_ID) CT
           FROM (SELECT T1.REQUESTER_ID FROM T0107 T1 UNION ALL SELECT T2.ACCEPTER_ID FROM T0107 T2) X
           GROUP BY X.REQUESTER_ID)
SELECT B.REQUESTER_ID AS "id", B.CT AS "num"
FROM (SELECT A.REQUESTER_ID, A.CT, MAX(A.CT) OVER () MX FROM A) B
WHERE B.CT = B.MX;