题解 | 电商平台需要对商品的销售和评价情况进行综合分析

电商平台需要对商品的销售和评价情况进行综合分析

https://www.nowcoder.com/practice/ccb441966a0342f2ab5fa8e76c33a3e6

with q_temp as (
select 
p.product_id,product_name,sum(quantity) as total_quantity
from products_underline p
join sales_underline  s on s.product_id=p.product_id
group by p.product_id
)
select 
q.product_id,product_name,total_quantity,round(avg(rating) ,2) as average_rating
from q_temp q
join reviews_underline  r on r.product_id=q.product_id
group by q.product_id
having avg(rating)<4
order by average_rating,q.product_id;

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务