一、题目
二、代码
# Write your MySQL query statement below
select Prices.product_id, coalesce(round(sum(price*units) / sum(units),2),0) as average_price from Prices
left join UnitsSold
on Prices.product_id = UnitsSold.product_id
and datediff(Prices.end_date ,UnitsSold.purchase_date )>=0
and datediff(Prices.start_date ,UnitsSold.purchase_date )<=0
group by Prices.product_id