题解 | 分析各产品线在特定时间段内的销售情况
分析各产品线在特定时间段内的销售情况
https://www.nowcoder.com/practice/8a002dd7888b4247b6ac9228577bdbc3
select product_line,region,channel_name,sum(sale_amount) as total_sale_amount, count(*) as total_sale_quantity from oppo_products left join sales_data using(product_id) left join sales_channels using(channel_id) group by product_line,region,channel_name order by product_line asc;
查看3道真题和解析