代码： # Write your MySQL query statement belowselect product_id,ifnull(round(sum(sum)/sum(units),2),0) as average_pricefrom(select p.product_id,p.price,u.units,price*units as sumfromPrices p le