[리트코드/SQL] 22. Find Followers Count (1729)

 

👉https://leetcode.com/problems/find-followers-count/?envType=study-plan&id=sql-i

Find Followers Count - LeetCode

---

🤔 문제 분석

1) Write an SQL query that will, for each user, return the number of followers.

2) Return the result table ordered by user_id in ascending order.

 

💡 풀이

SELECT date_id, make_name, 
	   COUNT(DISTINCT lead_id) AS unique_leads, 
	   COUNT(DISTINCT partner_id) AS unique_partners
FROM DailySales
GROUP BY date_id, make_name