leetcode

commit ed91d32af427a2eb5073440e0ad809711041c5f2
parent da92487181d490b3495401c42e87233e486676d1
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Wed, 12 Jul 2023 15:18:26 -0500

Completed leads using mySQL

Diffstat:
A
daily-leads-and-parners/daily-leads.sql
 | 
6
++++++

1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/daily-leads-and-parners/daily-leads.sql b/daily-leads-and-parners/daily-leads.sql
@@ -0,0 +1,6 @@
+--Given all leads return the
+--number of unique leads by brand
+--and employee
+SELECT DailySales.date_id, DailySales.make_name, COUNT(DISTINCT DailySales.lead_id) as unique_leads, COUNT(DISTINCT DailySales.partner_id) as unique_partners
+FROM DailySales
+GROUP BY DailySales.make_name, DailySales.date_id