I have following table:
CREATE TABLE entries (
utc TEXT,
entry INTEGER
);
with following data:
INSERT INTO entries
(utc, entry)
VALUES
('2022-10-01 01:54', 23),
('2022-10-04 02:40', 46),
('2022-10-09 16:20', 51),
('2022-10-10 04:05', 81),
('2022-10-16 12:26', 78);
How can I write a query to get the daily value (linear interpolated) like this:
utc | entry
-----------------|------
2022-10-01 00:00 | …
2022-10-02 00:00 | …
2022-10-03 00:00 | …
… | …
Here is a pre-filled dbfiddle for playing around: https://dbfiddle.uk/TCX9Rd5t
but I don't know the values since they are supposed to be calculated by the query I'm looking for
? If you have two entries for date2022-10-01
let's say 23 and 55 , would the result be2022-10-01 00:00 | 78
?