Problem Description –
Write an SQL query that will, for each user, return the number of followers.
Return the result table ordered by
The query result format is in the following example.
Problem Link – Follower count
Difficulty Level – Easy
SELECT user_id, COUNT(DISTINCT follower_id) as followers_count FROM Followers GROUP BY 1 ORDER BY 1