[LeetCode] 1251. Average Selling Price

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT p.product_id
     , IFNULL(ROUND(SUM(p.price * u.units) / SUM(u.units), 2), 0) AS average_price
FROM Prices AS p
    LEFT JOIN UnitsSold AS u ON p.product_id = u.product_id
                             AND (u.purchase_date BETWEEN p.start_date AND p.end_date)
GROUP BY product_id