题解 | 电商平台想要了解不同商品在不同月份的销售趋势
电商平台想要了解不同商品在不同月份的销售趋势
https://www.nowcoder.com/practice/a3fab87aca9347c28f406088cf601c7b
select product_id,product_name,sum(quantity) as total_sales,max(quantity) as max_monthly_sales,min(quantity) as min_monthly_sales,round(avg(quantity),0) as avg_monthly_sales from products_underline p join sales_underline s using(product_id) where sale_month between '2024-01' and '2024-06' group by product_id,product_name

美团工作强度 2569人发布
查看10道真题和解析