FilesExpand file tree

main

/

1729_find_followers_count.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

5 lines (5 loc) · 105 Bytes

main

/

1729_find_followers_count.sql

Copy path

Top

File metadata and controls

• Code
• Blame

5 lines (5 loc) · 105 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

SELECT user_id,

COUNT(*) AS followers_count

FROM followers

GROUP BY user_id

ORDER BY user_id;