자료구조 알고리즘/코딩테스트
1565. Unique Orders and Customers Per Month
내공얌냠
2022. 6. 24. 21:28
https://leetcode.com/problems/unique-orders-and-customers-per-month/
Account Login - 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_format(order_date, '%Y-%m') as month, count(distinct order_id) as order_count, count(distinct customer_id) as customer_count
from Orders
where invoice > 20
group by month728x90
반응형