题目:原题链接(简单)
标签:SQL
解法 | 时间复杂度 | 空间复杂度 | 执行用时 |
---|---|---|---|
Ans 1 (SQL) | – | – | 364ms (43.84%) |
Ans 2 (SQL) | |||
Ans 3 (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;