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

我的解法真是太优雅啦