1693.Daily-Leads-and-Partners.sql

--MySQL & MS SQL Server
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;