leetcode-Average Selling Price

dogndaxiaodong

于 2019-12-29 14:55:38 发布

阅读量514

点赞数

分类专栏： leetcode sql 文章标签： leetcode sql

本文链接：https://blog.youkuaiyun.com/weixin_41327340/article/details/103753717

版权

leetcode 同时被 2 个专栏收录

41 篇文章

订阅专栏

sql

7 篇文章

订阅专栏

# Write your MySQL query statement below

select p.product_id,round(sum(p.price*u.units)/sum(u.units),2) as average_price from Prices p join UnitsSold u on p.product_id = u.product_id where u.purchase_date between p.start_date and p.end_date group by p.product_id

描述一下sql顺序:from->join->where->group by ->select