select
     year(action_date) as year,
     ifnull(null, ' ') as month,
     ' ' as day,
     sum(qty*price) as total
from actions
group by year
union
select    
    ' ',
    month(action_date),
    ' ',
    sum(qty*price)
from actions
group by year(action_date), month(action_date)
union
select
  ' ',
    ' ',
    day(action_date),
    sum(qty*price)
from actions
group by year(action_date), month(action_date), day(action_date)

-- Тестовый набор данных:
with 
  b$m_tst_tbl as
    (
      select cast('2023-01-01' as date) as dt, 10 as summ union all
      select cast('2023-01-01' as date) as dt, 10 as summ union all
      select cast('2023-01-02' as date) as dt, 10 as summ union all
      select cast('2023-01-02' as date) as dt, 10 as summ union all
      select cast('2023-02-01' as date) as dt, 10 as summ union all
      select cast('2023-02-01' as date) as dt, 10 as summ union all
      select cast('2023-02-02' as date) as dt, 10 as summ union all
      select cast('2023-02-02' as date) as dt, 10 as summ union all
      select cast('2023-02-02' as date) as dt, 10 as summ union all
      select cast('2023-03-01' as date) as dt, 10 as summ union all
      select cast('2023-03-02' as date) as dt, 10 as summ union all
      select cast('2024-01-01' as date) as dt,  5 as summ union all
      select cast('2024-01-01' as date) as dt,  5 as summ union all
      select cast('2024-01-02' as date) as dt,  5 as summ union all
      select cast('2024-01-02' as date) as dt,  5 as summ union all
      select cast('2024-02-01' as date) as dt,  5 as summ union all
      select cast('2024-02-01' as date) as dt,  5 as summ union all
      select cast('2024-02-02' as date) as dt,  5 as summ union all
      select cast('2024-02-02' as date) as dt,  5 as summ union all
      select cast('2024-02-02' as date) as dt,  5 as summ union all
      select cast('2024-03-01' as date) as dt,  5 as summ union all
      select cast('2024-03-02' as date) as dt,  5 as summ 
	)
--
-- Основной запрос:
select case grouping_id(format(dt,'yyyy-MM-dd'), format(dt, 'yyyy-MM'), format(dt, 'yyyy')) 
         when 3 then 'За день:  ' + format(dt,'yyyy-MM-dd')
         when 5 then 'За месяц: '+ format(dt, 'yyyy-MM')
         when 6 then 'ЗА ГОД: '+ format(dt, 'yyyy')
         when 7 then 'ИТОГО: '
         else 'х.з. :)'
       end as [Период]
     , sum(summ) as [Сумма]
     , count(summ) as [Кол-во]
  from b$m_tst_tbl
 group by grouping sets(format(dt,'yyyy-MM-dd'), format(dt, 'yyyy-MM'), format(dt, 'yyyy'),())
 order by coalesce(
                      format(dt,'yyyy-MM-dd')
                    , format(dt,'yyyy-MM')+'-33'
                    , format(dt,'yyyy')+'-13-00'
                    , '9999-99-99'
                  );