SELECT YEAR(a.action_date) AS YEAR,IFNULL(" "," ") AS MONTH,IFNULL(" "," ") AS DAY, SUM(a.price * a.qty) AS SUM
FROM actions AS a
GROUP BY YEAR
UNION ALL
SELECT IFNULL(" "," ") AS YEAR, CASE MONTH(a.action_date)
WHEN 1 THEN 'январь' 
WHEN 2 THEN 'февраль' 
WHEN 3 THEN 'март' 
WHEN 4 THEN 'апрель' 
WHEN 5 THEN 'май' 
WHEN 6 THEN 'июнь' 
WHEN 7 THEN 'июль' 
WHEN 8 THEN 'август' 
WHEN 9 THEN 'сентябрь' 
WHEN 10 THEN 'октябрь' 
WHEN 11 THEN 'ноябрь' 
WHEN 12 THEN 'декабрь'
END AS MONTH,IFNULL(" "," ") AS DAY, SUM(a.price * a.qty) AS SUM
FROM actions AS a
GROUP BY MONTH
UNION ALL
SELECT IFNULL(" "," ") AS YEAR,IFNULL(" "," ") AS MONTH,DATE(a.action_date) AS DAY, SUM(a.price * a.qty) AS SUM
FROM actions AS a
GROUP BY DAY
ORDER BY DAY;