[리트코드/SQL] 21. Daily Leads and Partners (1693)

👉https://leetcode.com/problems/daily-leads-and-partners/description/?envType=study-plan&id=sql-i

Daily Leads and Partners - LeetCode

 

---

🤔 문제 분석

1) Write an SQL query that will, for each date_id and make_name, return the number of distinct lead_id's and distinct partner_id's.

2) Return the result table in any 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