SQLize Online / PHPize Online  /  SQLtest Online

create table t (`user_id` int, `action_type` varchar(32), `value` int, `datetime` datetime); insert into t values (1, 'value_add', 20, '2022-12-31 10:00:00'), (2, 'value_add', 50, '2022-12-31 11:00:00'), (3, 'value_remove', 200, '2022-12-30 09:00:00'), (3, 'value_remove', 250, '2022-12-30 14:00:00'), (4, 'value_add', 300, '2022-12-30 15:00:00'), (5, 'value_remove', 100, '2022-12-31 22:00:00'); select date(`datetime`), sum(case when `action_type` = 'value_add' then `value` else -`value` end) `total` from t group by date(`datetime`)