# #1693 Daily Leads and Partners

#### [https://leetcode.com/problems/daily-leads-and-partners/](https://leetcode.com/problems/daily-leads-and-partners/)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
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
```
{% endtab %}
{% endtabs %}
