SQL_LeetCode_1251_Average Selling Price

SQL_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 p LEFT JOIN unitssold u ON p.product_id = u.product_id AND u.purchase_date BETWEEN p.start_date AND p.end_date GROUP BY p.product_id; -- mssql SELECT p.product_id , ISNULL(ROUND(SUM(p.price * u.units) * 1.0 / SUM(u.units), 2), 0) as average_price FROM prices p LEFT JOIN unitssold u ON p.product_id = u.product_id AND u.purchase_date BETW...

원문링크 : SQL_LeetCode_1251_Average Selling Price