[문제]
[MySQL]
WITH Activity AS (
SELECT requester_id AS id
FROM RequestAccepted
UNION ALL
SELECT accepter_id AS id
FROM RequestAccepted
)
SELECT id
, COUNT(*) AS num
FROM Activity
GROUP BY id
ORDER BY num DESC
LIMIT 1
'SQL > LeetCode' 카테고리의 다른 글
| [LeetCode] 608. Tree Node (0) | 2025.02.18 |
|---|---|
| [LeetCode] 607. Sales Person (0) | 2025.02.18 |
| [LeetCode] 601. Human Traffic of Stadium (0) | 2025.02.18 |
| [LeetCode] 596. Classes More Than 5 Students (0) | 2025.02.18 |
| [LeetCode] 595. Big Countries (0) | 2025.02.18 |