leetcode

0 SELECT P.product_id, IFNULL(ROUND(SUM(price * units) / SUM(units), 2), 0) AS average_price

1 FROM Prices P

2 LEFT JOIN UnitsSold U

3 ON P.product_id = U.product_id AND

4 purchase_date BETWEEN start_date AND end_date

5 GROUP BY P.product_id