By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET DATEFIRST 1;
;with ESP_LOG as
(
SELECT ID, ID_STR,
[Time], SHIFTED_TIME,
ID_op, Hodnota1
FROM
(
VALUES
(14995679, 78, '2021-01-03 05:44:01.577', 1, 36),
(14995680, 78, '2021-01-08 21:44:56.697', 1, 5),
(14995682, 78, '2021-01-08 23:45:51.837', 1, 20),
(14995683, 77, '2021-01-10 21:46:08.497', 1, 5),
(14995684, 78, '2021-01-10 22:46:46.913', 1, 11),
(14995685, 77, '2021-01-12 20:47:03.573', 1, 8),
(14995686, 78, '2021-01-19 21:47:41.997', 1, 19),
(14995687, 77, '2021-01-26 20:47:58.657', 1, 5)
) v (ID, ID_STR, [Time], ID_op, Hodnota1)
CROSS APPLY
(
SELECT SHIFTED_TIME = DATEADD(HOUR, 2, [Time])
) S
)
SELECT DATEPART(WEEK, SHIFTED_TIME) -1 AS WeekDay,
SUM(Hodnota1) AS total_sales
FROM [ESP_LOG]
WHERE Time BETWEEN '2020-01-01 00:00:00' AND '2021-12-31 00:00:00'
--AND ID_op = 1 AND ID_MACH IN(SELECT TOP (1000) ID FROM [Database].[dbo].[MACH] Where ZAOR_Org = 'PRI')
GROUP BY DATEPART(WEEK, SHIFTED_TIME) -1
ORDER BY 1
| WeekDay | total_sales |
|---|---|
| 0 | 36 |
| 1 | 30 |
| 2 | 19 |
| 3 | 19 |
| 4 | 5 |