1693.sql (180B)
1 SELECT date_id, 2 make_name, 3 COUNT(DISTINCT lead_id) AS unique_leads, 4 COUNT(DISTINCT partner_id) AS unique_partners 5 FROM DailySales 6 GROUP BY date_id, make_name