MySQL 8.0

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

CREATE TABLE users (
  id INTEGER AUTO_INCREMENT PRIMARY kEY,
  name VARCHAR(100) NULL
);
INSERT INTO users(name) VALUES 
('Jack'), 
('John'), 
('Jane');

CREATE TABLE user_spents (
  id INTEGER AUTO_INCREMENT PRIMARY kEY,
  user_id INTEGER NOT NULL,
  spent DOUBLE DEFAULT 0,
  date DATE NOT NULL
);

INSERT INTO user_spents(user_id, date, spent) VALUES
(1, '2022-04-01', 2.00),
(1, '2022-04-01', 1.00),
(1, '2022-04-01', 5.00),
(1, '2022-04-02', 3.00),
(1, '2022-04-02', 1.00),
(1, '2022-04-04', 7.00),
(2, '2022-04-01', 6.00),
(2, '2022-04-03', 44.00),
(2, '2022-04-04', 13.00),
(3, '2022-04-01', 6.00),
(3, '2022-04-04', 13.00);

CREATE TABLE user_incomes (
  id INTEGER AUTO_INCREMENT PRIMARY kEY,
  user_id INTEGER NOT NULL,
  income DOUBLE DEFAULT 0,
  date DATE NOT NULL
);

INSERT INTO user_incomes(user_id, date, income) VALUES
(1, '2022-04-03', 44.00),
(1, '2022-04-02', 15.00),
(1, '2022-04-02', 41.00),
(1, '2022-04-01', 12.00),
(2, '2022-04-01', 54.00),
(2, '2022-04-02', 4.00),
(2, '2022-04-03', 2.00),
(3, '2022-04-01', 15.00),
(3, '2022-04-03', 99.00),
(3, '2022-04-04', 23.00);

user_id	name	activity_date	spent	income
1	Jack	2022-04-01	0	12
1	Jack	2022-04-01	8	0
1	Jack	2022-04-02	4	0
1	Jack	2022-04-02	0	56
1	Jack	2022-04-03	0	44
1	Jack	2022-04-04	7	0
2	John	2022-04-01	6	0
2	John	2022-04-01	0	54
2	John	2022-04-02	0	4
2	John	2022-04-03	44	0
2	John	2022-04-03	0	2
2	John	2022-04-04	13	0
3	Jane	2022-04-01	6	0
3	Jane	2022-04-01	0	15
3	Jane	2022-04-03	0	99
3	Jane	2022-04-04	13	0
3	Jane	2022-04-04	0	23