select
    product_line,
    region,
    channel_name,
    sum(sale_amount) as total_sale_amount,
    count(*) as total_sale_quantity
from 
    oppo_products as o
    left join sales_data as sd on o.product_id = sd.product_id
    left join sales_channels as sc on sc.channel_id = sd.channel_id
group by sc.channel_id, product_line, region, channel_name
order by product_line, sc.channel_id