자료구조 알고리즘/코딩테스트
1251. Average Selling Price
내공얌냠
2022. 6. 24. 22:00
https://leetcode.com/problems/average-selling-price/
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 a.product_id, round(sum(a.price * b.units)/sum(b.units), 2) as average_price
from Prices as a
left outer join UnitsSold as b
on a.product_id = b.product_id
and b.purchase_date between a.start_date and a.end_date
group by product_id728x90
반응형