-
1693. Daily Leads and Partners mysqlLeetCode_Study_Plan/SQL 2022. 10. 2. 14:35
https://leetcode.com/problems/daily-leads-and-partners/?envType=study-plan&id=sql-i
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;
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
586. Customer Placing the Largest Number of Orders mysql (0) 2022.10.02 1729. Find Followers Count mysql (0) 2022.10.02 1141. User Activity for the Past 30 Days I mysql (0) 2022.10.02 176. Second Highest Salary mysql (0) 2022.10.02 608. Tree Node mysql (0) 2022.10.02