By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.30 |
CREATE TABLE billing(
item_cost NUMERIC(9,2) NOT NULL PRIMARY KEY
,bill_date DATETIME NOT NULL
);
INSERT INTO billing(item_cost,bill_date) VALUES (15124.53,'2022-03-30 00:51:26');
INSERT INTO billing(item_cost,bill_date) VALUES (21053.62,'2022-03-30 00:51:26');
INSERT INTO billing(item_cost,bill_date) VALUES (65255.20,'2022-03-30 00:51:26');
INSERT INTO billing(item_cost,bill_date) VALUES (500.34,'2022-03-30 00:51:26');
INSERT INTO billing(item_cost,bill_date) VALUES (400.00,'2022-03-30 00:51:26');
INSERT INTO billing(item_cost,bill_date) VALUES (106656.91,'2022-03-30 13:13:25');
INSERT INTO billing(item_cost,bill_date) VALUES (9499.76,'2022-03-30 15:40:53');
INSERT INTO billing(item_cost,bill_date) VALUES (9499.76,'2022-03-30 15:43:45');
INSERT INTO billing(item_cost,bill_date) VALUES (880.23,'2022-03-30 15:53:12');
-- 2nd table
CREATE TABLE second(
d datetime);
INSERT INTO second VALUES
('2022-03-30 13:00:00'),
('2022-03-30 18:00:00');
SELECT
second.d,
sum(CASE WHEN bill_date<second.d THEN item_cost END) as SUM
FROM billing
CROSS JOIN second
GROUP BY second.d
ORDER BY second.d
| d | SUM |
|---|---|
| 2022-03-30 13:00:00 | 102333.69 |
| 2022-03-30 18:00:00 | 218490.36 |