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