1693-daily-leads-and-partners

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

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