[코드카타] SQL 42 Find Followers Count

Data_Student·6일 전
0

코드카타

목록 보기
51/57

[코드카타] SQL 42 Find Followers Count

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

Write a solution that will, for each user, return the number of followers.
Return the result table ordered by user_id in ascending order.
Select user_id, count(follower_id) followers_count
From Followers
group by user_id
order by user_id
오랜만에 정렬(order by)이 문제로 제시..!!

0개의 댓글