MariaDB 10.2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE payment (
id INT,
amount INT,
type VARCHAR(255),
time DATETIME,
PRIMARY KEY (id)
);
INSERT INTO payment (id, type, time, amount)
VALUES (18, 'depo', '2020-02-02 10:13:00', 30),
(17, 'full', '2020-02-02 10:12:00', 100),
(16, 'full', '2020-02-01 15:12:00', 100),
(15, 'full', '2020-02-01 13:12:00', 100)
;
SELECT * from payment;


id
amount
type
time


15
100
full
2020-02-01 13:12:00

16
100
full
2020-02-01 15:12:00

17
100
full
2020-02-02 10:12:00

18
30
depo
2020-02-02 10:13:00


    SELECT sum(case when type = 'depo' then - amount else amount end) amount, DATE(time) day 
      FROM `payment` 
      WHERE type IN ('full', 'depo')
     GROUP BY day 
     ORDER BY day


amount
day


200
2020-02-01

70
2020-02-02

id	amount	type	time
15	100	full	2020-02-01 13:12:00
16	100	full	2020-02-01 15:12:00
17	100	full	2020-02-02 10:12:00
18	30	depo	2020-02-02 10:13:00