리트코드(LeetCode) SQL 문제풀이 - 1693. Daily Leads and Partners
2023. 1. 26. 17:41ㆍ코딩테스트/리트코드(LeetCode) - SQL Study Plan
MySQL 문제 1693. Daily Leads and Partners
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_name728x90
'코딩테스트 > 리트코드(LeetCode) - SQL Study Plan' 카테고리의 다른 글
| 리트코드(LeetCode) SQL 문제풀이 - 586. Customer Placing the Largest Number of Orders (0) | 2023.01.26 |
|---|---|
| 리트코드(LeetCode) SQL 문제풀이 - 1729. Find Followers Count (0) | 2023.01.26 |
| 리트코드(LeetCode) SQL 문제풀이 - 1141. User Activity for the Past 30 Days I (0) | 2023.01.26 |
| 리트코드(LeetCode) SQL 문제풀이 - 607. Sales Person (0) | 2023.01.26 |
| 리트코드(LeetCode) SQL 문제풀이 - 197. Rising Temperature (0) | 2023.01.26 |