sql_prequery.sql

;WITH hours as (
  ...
),
incomes as (
  SELECT * 
  FROM sensor_triggers
  WHERE ...
  GROUP BY hour(created_at)
),
outcomes as (
  SELECT * 
  FROM sensor_triggers
  WHERE ...
  GROUP BY hour(created_at)
),
rows as (
  SELECT *
  FROM hours
  LEFT JOIN incomes on incomes.hour = hours.hour
  LEFT JOIN outcomes on outcomes.hour = hours.hour
),
final_row as (
  SELECT 
    'Итог' literal
    sum(rows.incomes),
    sum(rows.outcomes)
  FROM rows
)
SELECT * FROM rows
UNION
select * FROM final_row