Subscriber Tally

For each user, return the number of followers as followers_count. Sort the result by user_id in ascending order.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

user_id	followers_count
1	3
2	3
3	2

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid