SELECT calendaryear AS Year, 
    COALESCE(countryname,'All countries') AS Country,
    COALESCE(channelname, 'All channels') AS Channel, 
    COUNT(DISTINCT orderkey) AS Orders_Num
FROM dimorderchannel doc 
    INNER JOIN factonlinesales fos
         ON doc.channelkey = fos.channelkey
    INNER JOIN dimdate dd 
         ON dd.datekey = fos.orderdatekey 
    INNER JOIN dimsalesterritory dst
         ON dst.salesterritorykey = fos.salesterritorykey
WHERE salesterritoryname = 'NACA' AND calendaryear IN (2023, 2024)
GROUP BY calendaryear, countryname, ROLLUP(channelname) ;