select
    p.product_line,
    c.region,
    c.channel_name,
    sum(s.sale_amount) as total_sale_amount,
    count(s.sale_id) as total_sale_quantity
from sales_data s
left join oppo_products p on s.product_id=p.product_id
left join sales_channels c on s.channel_id=c.channel_id
group by p.product_line,c.channel_name,c.region,s.channel_id
order by p.product_line,s.channel_id