image_2022-03-28_17-12-32.png
22.1 KB
#N1693. Daily Leads and Partners
problem link
#solution
problem link
#solution
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;