AG
Size: a a a
AG
AG
B
N
AD
Z
SELECT
"st",
round(AVG("core_tankdata"."volume")::numeric, 2) as "avg_volume",
round(AVG("core_tankdata"."density")::numeric, 3) as "avg_density",
round(AVG("core_tankdata"."mass")::numeric, 2) as "avg_mass",
round(AVG("core_tankdata"."level")::numeric, 2) as "avg_level"
FROM generate_series('2019-01-01 00:00:00+06:00', '2020-04-23 23:59:59+06:00', interval '1 hour') as st, "core_tankdata"
WHERE ("core_tankdata"."record_time" >= st AND "core_tankdata"."record_time" < st + '1 hour')
GROUP BY st ORDER BY st ASC
round(AVG("core_tankdata"."volume")::numeric, 2) as "avg_volume",
round(AVG("core_tankdata"."density")::numeric, 3) as "avg_density",
round(AVG("core_tankdata"."mass")::numeric, 2) as "avg_mass",
round(AVG("core_tankdata"."level")::numeric, 2) as "avg_level"
А
T
А
T
А
T
T
А
А
А
А
А
А
А