[LeetCode/SQL] 1693. Daily Leads and Partners

[LeetCode/SQL]

---

📌 1693. Daily Leads and Partners

문제

풀이

- date_id 별,make_name 별
중복없는 리드 수, 중복없는 파트너 수 

방법

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