union

SELECT 'hello', count(*) from "826887-1298";


SELECT time_bucket('1 day', ts) AS bucket, value, id
    FROM "826887-1298"
    WHERE ts > now() - INTERVAL '32 days'
    GROUP BY bucket, value, id
    ORDER BY bucket; -- 331 - 620 = 289

SELECT time_bucket('1 day', ts) AS bucket, avg(value)
    FROM "826887-1298"
    WHERE ts > now() - INTERVAL '10 days'
    GROUP BY bucket
    ORDER BY bucket;


-- union

SELECT time_bucket('1 day', a.ts) AS bucket, avg(value)
    FROM "826887-1298" a
    WHERE ts > now() - INTERVAL '10 days'
    GROUP BY bucket
    ORDER BY bucket
UNION
SELECT time_bucket('1 day', b.ts) AS bucket2, avg(value)
    FROM "826887-1298" b
    WHERE ts > now() - INTERVAL '10 days'
    GROUP BY bucket2
    ORDER BY bucket2;



    SELECT '826887-1298' as sub_id, time_bucket('1 day', ts) AS bucket, avg(value)
        FROM "826887-1298"
        WHERE ts > now() - INTERVAL '12 days'
        GROUP BY bucket
UNION
    SELECT '826886-1298' as sub_id, time_bucket('1 day', ts) AS bucket, avg(value)
        FROM "826886-1298"
        WHERE ts > now() - INTERVAL '12 days'
        GROUP BY bucket
UNION
    SELECT '826892-1298' as sub_id, time_bucket('1 day', ts) AS bucket, avg(value)
        FROM "826892-1298"
        WHERE ts > now() - INTERVAL '12 days'
        GROUP BY bucket
ORDER BY sub_id, bucket;


SELECT * from "826887-1298"
    WHERE ts > now() - INTERVAL '32 days'; -- 105 - 392 = - 287