SQLize Online / PHPize Online  /  SQLtest Online

create table tbl (date_time datetime, user_id int, price int); insert into tbl values ('2020-01-01 01:05:30', 1, 10), ('2020-01-01 02:45:33', 3, 20), ('2020-03-25 11:10:15', 66, 10), ('2020-04-21 00:40:00', 21, 40), ('2020-04-22 15:00:00', 70, 30), ('2020-04-22 20:00:00', 21, 10); select dates.date_time dates, count(distinct tbl.user_id), sum(tbl.price) from ( select distinct date(tbl.date_time) date_time from tbl ) dates join tbl on dates.date_time >= date(tbl.date_time) group by dates.date_time order by dates.date_time;