MySQL 5.7

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

CREATE TABLE users_emotions (
  id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
  user_id INT,
  emotion VARCHAR(20),
  registered_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users_emotions (user_id, emotion, registered_on) VALUES
  (1, 'SAD',   '2021-04-05 09:01:00'),
  (1, 'SAD',   '2021-04-05 10:01:00'),
  (1, 'HAPPY', '2021-04-05 11:01:00');

INSERT INTO users_emotions (user_id, emotion, registered_on) VALUES
  (2, 'SAD',   '2021-05-05 09:01:00'),
  (2, 'HAPPY', '2021-05-05 10:01:00'),
  (2, 'SAD',   '2021-05-05 11:01:00'),
  (2, 'HAPPY', '2021-05-05 12:01:00'),
  (2, 'HAPPY', '2021-05-05 13:01:00'),
  (2, 'SAD',   '2021-05-05 14:01:00');

INSERT INTO users_emotions(user_id, emotion, registered_on) VALUES
  (3, 'HAPPY',    '2021-05-05 09:01:00'),
  (3, 'SAD',      '2021-05-05 10:01:00'),
  (3, 'CONFUSED', '2021-05-05 11:01:00'),
  (3, 'CONFUSED', '2021-05-05 12:01:00'),
  (3, 'SAD',      '2021-05-05 13:01:00'),
  (3, 'CONFUSED', '2021-05-05 14:01:00');

INSERT INTO users_emotions(user_id, emotion, registered_on) VALUES
  (4, 'HAPPY', '2021-05-05 09:01:00'),
  (4, 'HAPPY', '2021-05-05 10:01:00'),
  (4, 'ANGRY', '2021-05-05 11:01:00'),
  (4, 'ANGRY', '2021-05-05 12:01:00'),
  (4, 'BORED', '2021-05-05 13:01:00'),
  (4, 'HAPPY', '2021-05-05 14:01:00'),
  (4, 'BORED', '2021-05-05 15:01:00'),
  (4, 'ANGRY', '2021-05-05 16:01:00'),
  (4, 'BORED', '2021-05-05 17:01:00'),
  (4, 'BORED', '2021-05-05 18:01:00'),
  (4, 'BORED', '2021-05-05 19:01:00'),
  (4, 'BORED', '2021-05-05 20:01:00'),
  (4, 'BORED', '2021-05-05 21:01:00');

Records: 3  Duplicates: 0  Warnings: 0

Records: 6  Duplicates: 0  Warnings: 0

Records: 6  Duplicates: 0  Warnings: 0

Records: 13  Duplicates: 0  Warnings: 0

user_id	year	emotion
1	2021	SAD
2	2021	HAPPY
3	2021	CONFUSED
4	2021	BORED