leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

daily-leads.sql (302B)

      1 --Given all leads return the
      2 --number of unique leads by brand
      3 --and employee
      4 SELECT DailySales.date_id, DailySales.make_name, COUNT(DISTINCT DailySales.lead_id) as unique_leads, COUNT(DISTINCT DailySales.partner_id) as unique_partners
      5 FROM DailySales
      6 GROUP BY DailySales.make_name, DailySales.date_id