select left_part.series_service_id, left_part.series_group_id,
       array_agg(coalesce(greatest(fi.required_operator_number, fi.min_count_operators) * fi.operator_number_coefficient, 0)::integer)
from (select * from generate_series('2019-01-01', '2020-01-01', 5 * interval '1 minute'),
          (values (418470, 418492),
                  (100019, 3496786),
                  (418470, 120),
                  (418470, 418534),
                  (418470, 418536),
                  (418470, 418566),
                  (418470, 4143048),
                  (418470, 5314485),
                  (418470, 5332556),
                  (418470, 5735478),
                  (418470, 13982061),
                  (418470, 13982095),
                  (418470, 14076077),
                  (495527, 9),
                  (495527, 13),
                  (495527, 106),
                  (495527, 110),
                  (495527, 127),
                  (495527, 131),
                  (495527, 138),
                  (495527, 155),
                  (495527, 566712),
                  (495527, 566713),
                  (495527, 782142),
                  (495527, 782157),
                  (495527, 3014424),
                  (495527, 3496131),
                  (495527, 13780456),
                  (495527, 13780475),
                  (495527, 13780493),
                  (495527, 13781343),
                  (782187, 416030),
                  (782187, 782195),
                  (782187, 13780503)) as val (series_service_id, series_group_id)) left_part
         left join forecast_interval fi
                   on fi.service_id = left_part.series_service_id and fi.group_id = left_part.series_group_id and left_part.generate_series = fi.start_timestamp
group by left_part.series_service_id, left_part.series_group_id