sql16（Leetcode1251平均售价）

本文主要是介绍sql16（Leetcode1251平均售价），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

代码：

# Write your MySQL query statement belowselect product_id,ifnull(round(sum(sum)/sum(units),2),0) as average_price
from(select p.product_id,p.price,u.units,price*units as sumfromPrices p        left join UnitsSold uon u.product_id=p.product_id and datediff(u.purchase_date,p.start_date)>=0 and datediff(u.purchase_date,p.end_date)<=0
) t
group by product_id

这篇关于sql16（Leetcode1251平均售价）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---