2023/03/17

Leetcode Note: MySQL - Find Followers Count

Find Followers Count - LeetCode
https://leetcode.com/problems/find-followers-count/

MySQL で取り組んだメモ

回答

Simple SQL query - Find Followers Count - LeetCode
https://leetcode.com/problems/find-followers-count/solutions/1021950/simple-sql-query/

select
    user_id,
    count(*) as followers_count
from
    Followers
group by
    user_id
order by
	user_id