LeetCode-Solutions/MySQL/activity-participants.sql at master · hackto-dev/LeetCode-Solutions · GitHub

18 lines (17 loc) · 645 Bytes

# Time: O(n)

# Space: O(n)

SELECT activity

FROM friends

GROUP BY activity

HAVING Count(1) NOT IN (SELECT Max(counts)

FROM (SELECT Count(1) AS counts

FROM friends

GROUP BY activity

ORDER BY NULL) a

UNION ALL

SELECT Min(counts)

FROM (SELECT Count(1) AS counts

FROM friends

GROUP BY activity

ORDER BY NULL) b)

ORDER BY NULL;

Expand file tree