题目描述
leetcode题目: 1693. 每天的领导和合伙人
Code
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
leetcode题目: 1693. 每天的领导和合伙人
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