WITH working_hours_table (working_hours, date_at) AS (
VALUES (136, '2024-01-01'::DATE),
(159, '2024-02-01'::DATE),
(159, '2024-03-01'::DATE),
(168, '2024-04-01'::DATE),
(159, '2024-05-01'::DATE),
(151, '2024-06-01'::DATE),
(184, '2024-07-01'::DATE),
(176, '2024-08-01'::DATE),
(168, '2024-09-01'::DATE),
(184, '2024-10-01'::DATE),
(167, '2024-11-01'::DATE),
(168, '2024-12-01'::DATE)
)
SELECT * FROM working_hours_table;
Виртуальная таблица SQL рабочих часов в 2024 году
27.03.2024