| # | 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|

select date_id, make_name,count(distinct(lead_id))as unique_leads,

count(distinct(partner_id))as unique_partnersfrom DailySalesgroup by date_id, make_name;