MySQL 8.0

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

CREATE TABLE mytable(
   USER_ID       VARCHAR(2)
  ,SURVEY_NAME   VARCHAR(10)
  ,QUESTION_NAME VARCHAR(2)
  ,UPDATE_DATE   DATE 
  ,RESPONSE      VARCHAR(4)
);
INSERT INTO mytable(USER_ID,SURVEY_NAME,QUESTION_NAME,UPDATE_DATE,RESPONSE) VALUES 
('A1','BIG_SURVEY','Q1','2022-01-01','BAD'),
('A1','BIG_SURVEY','Q2','2022-01-01','GOOD'),
('A1','BIG_SURVEY','Q3','2022-01-01','OK'),
('A1','BIG_SURVEY','Q1','2022-08-01','GOOD');
with cte as
(select USER_ID,SURVEY_NAME,QUESTION_NAME,UPDATE_DATE,RESPONSE, 
row_number() 
over(partition by USER_ID,SURVEY_NAME,QUESTION_NAME
order by UPDATE_DATE desc) rn
from mytable)
select USER_ID,SURVEY_NAME,QUESTION_NAME,UPDATE_DATE,RESPONSE
from cte
where rn = 1;


USER_ID
SURVEY_NAME
QUESTION_NAME
UPDATE_DATE
RESPONSE


A1
BIG_SURVEY
Q1
2022-08-01
GOOD

A1
BIG_SURVEY
Q2
2022-01-01
GOOD

A1
BIG_SURVEY
Q3
2022-01-01
OK

USER_ID	SURVEY_NAME	QUESTION_NAME	UPDATE_DATE	RESPONSE
A1	BIG_SURVEY	Q1	2022-08-01	GOOD
A1	BIG_SURVEY	Q2	2022-01-01	GOOD
A1	BIG_SURVEY	Q3	2022-01-01	OK