解决方案:
select date_id , make_name ,
count( distinct lead_id)as unique_leads ,
count( distinct partner_id) unique_partners
from DailySales
group by date_id, make_name
输出:
解决方案:
select date_id , make_name ,
count( distinct lead_id)as unique_leads ,
count( distinct partner_id) unique_partners
from DailySales
group by date_id, make_name
输出: