LeetCode_Study_Plan/SQL
1693. Daily Leads and Partners mysql
개발하는루루
2022. 10. 2. 14:35
https://leetcode.com/problems/daily-leads-and-partners/?envType=study-plan&id=sql-i
Daily Leads and Partners - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
SELECT date_id, make_name, COUNT(DISTINCT lead_id) AS unique_leads, COUNT(DISTINCT partner_id) AS unique_partners
FROM DailySales
GROUP BY 1, 2;