Find Followers Count _ Easy. LeetCode

 

Solution

SELECT user_id,
    COUNT(follower_id) followers_count
FROM Followers
GROUP BY user_id
ORDER BY user_id ASC;