clickhouse如何实现分别查询当天每个小时，本周的每一天，本月的每一天的数据，没有数据的补0

请教一下各位牛友， clickhouse如何实现分别查询当天每个小时，本周的每一天，本月的每一天的数据，没有数据的补0！

当天每个小时的数据

SELECT toHour(dateTime) AS hour, coalesce(sum(value), 0) AS value
FROM table
WHERE dateTime >= today() AND dateTime < today() + 1
GROUP BY hour

本周每一天的数据

SELECT toMonday(dateTime) AS day, coalesce(sum(value), 0) AS value
FROM table
WHERE dateTime >= toMonday(today()) AND dateTime < toMonday(today()) + 8
GROUP BY day

本月每一天的数据

SELECT toStartOfMonth(dateTime) AS day, coalesce(sum(value), 0) AS value
FROM table
WHERE dateTime >= toStartOfMonth(today()) AND dateTime < toStartOfMonth(today()) + interval 1 month
GROUP BY day