题解 | 分析各产品线在特定时间段内的销售情况

with a as (
    select product_line, channel_id, sum(sale_amount) as total_sale_amount, count(sale_id) as total_sale_quantity
    from sales_data join oppo_products using(product_id)
    group by product_line, channel_id
)
select product_line, region, channel_name, total_sale_amount, total_sale_quantity
from a join sales_channels using(channel_id)
order by product_line, channel_id

EASY