牛客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