[Leetcode] Daily Leads and Partners

문제 링크

정답

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

✅ Point

• COUNT(lead_id) 만으론 distinct 한 id의 개수를 구할 수 없음
• COUNT(DISTINCT lead_id) 로