牛客237430026号
牛客237430026号
全部文章
分类
归档
标签
去牛客网
登录
/
注册
牛客237430026号的博客
全部文章
(共2篇)
题解 | 分析每个商品在不同时间段的销售情况
with zw as ( select p.product_id, p.product_name, p.category, date_format(o.order_date,'%Y-%m') as date, ifnull(o.total_amount,0.00) as total_amount f...
2026-01-26
0
49
题解 | 统计每个产品的销售情况
with zw as( select o.product_id, sum(unit_price*quantity) as total_sales, sum(quantity) as total_quantity from orders o join...
2025-10-05
1
57