Skip to content

1693. Daily Leads and Partners 👍

1
2
3
4
5
6
7
SELECT
  date_id,
  make_name,
  COUNT(DISTINCT lead_id) AS unique_leads,
  COUNT(DISTINCT partner_id) AS unique_partners
FROM DailySales
GROUP BY 1, 2;