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