add 1693

fishercoder1534 · fishercoder1534 · commit 889a6c7660f1 · 2020-12-29T18:30:14.000-08:00
diff --git a/README.md b/README.md
@@ -1073,6 +1073,7 @@ _If you like this project, please leave me a star._ &#9733;
 
 |  #  |      Title     |   Solutions   | Video         | Difficulty    | Tag          
 |-----|----------------|---------------|---------------|---------------|-------------
+|1693|[Daily Leads and Partners](https://leetcode.com/problems/daily-leads-and-partners/)|[Solution](../master/database/_1693.sql) || Easy |
 |1607|[Sellers With No Sales](https://leetcode.com/problems/sellers-with-no-sales/)|[Solution](../master/database/_1607.sql) || Easy |
 |1581|[Customer Who Visited but Did Not Make Any Transactions](https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/)|[Solution](../master/database/_1581.sql) || Easy |
 |1543|[Fix Product Name Format](https://leetcode.com/problems/fix-product-name-format/)|[Solution](../master/database/_1543.sql) || Easy |
diff --git a/database/_1693.sql b/database/_1693.sql
@@ -0,0 +1,3 @@
+--# Write your MySQL query statement below
+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;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+--# Write your MySQL query statement below`
	`2`	`+select date_id, make_name, count(distinct(lead_id)) as unique_leads,`
	`3`	`+count(distinct(partner_id)) as unique_partners from DailySales group by date_id, make_name;`