1877. Find Followers Count
My accepted SQL solution to LeetCode problem 1877, Find Followers Count, running in 507ms.
- Difficulty: Easy
- SQL
- Runtime 507ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 507ms, memory 0.0B, accepted 2025-12-31.
SELECT user_id, COUNT(follower_id) AS followers_count
FROM Followers
GROUP BY user_id
ORDER BY user_id ASC