select product_line,region,channel_name,sum(sale_amount) as total_sale_amount,
count(*) as total_sale_quantity
from oppo_products
left join sales_data using(product_id)
left join sales_channels using(channel_id)
group by product_line,region,channel_name
order by product_line asc;