Skip to content

1729. Find Followers Count 👍

1
2
3
4
5
6
SELECT
  user_id,
  COUNT(follower_id) AS followers_count
FROM Followers
GROUP BY 1
ORDER BY 1;