SELECT c.channel_l1, c.channel_l2, sum(f.amount) AS amt
FROM fact_order f
JOIN dim_channel c ON f.channel_sk = c.channel_sk
GROUP BY c.channel_l1, c.channel_l2;