题解 | 分析各产品线在特定时间段内的销售情况
分析各产品线在特定时间段内的销售情况
https://www.nowcoder.com/practice/8a002dd7888b4247b6ac9228577bdbc3
select
product_line,
region,
channel_name,
sum(sale_amount) total_sale_amount,
count(sale_id) total_sale_quantity
from
sales_data s1
left join
sales_channels s2
using(channel_id)
left join
oppo_products s3
using(product_id)
group by 1,2,channel_id,3
order by 1,channel_id
我的解法真是太优雅啦

