select
    product_line
    ,region
    ,channel_name
    ,sum(sale_amount) total_sale_amount
    ,count(channel_name) total_sale_quantity
from sales_data sd
join oppo_products op on sd.product_id = op.product_id
join sales_channels sc on sd.channel_id = sc.channel_id
group by 1,2,3,sd.channel_id
order by 1,sd.channel_id