[코트카타 103]

103. Find Followers Count

 

Write a solution that will, for each user, return the number of followers.

Return the result table ordered by user_id in ascending order.

The result format is in the following example.

 

select user_id,

           count(follower_id) followers_count

from Followers

group by 1

order by 1