Maybe I forgot something, but it's something like this:

*documentation: https://docs.moodle.org/23/en/Configurable_reports

SELECT
    concat( u.firstname, " ", u.lastname ) AS "Student",
    q.name AS 'Form',
    que.name AS 'Question',
    qa.responsesummary AS 'Student Answer'

FROM prefix_quiz_attempts quiza

INNER JOIN prefix_quiz q ON q.id=quiza.quiz
INNER JOIN prefix_question_usages qu ON qu.id = quiza.uniqueid
INNER JOIN prefix_question_attempts qa ON qa.questionusageid = qu.id
INNER JOIN prefix_question que ON que.id = qa.questionid
INNER JOIN prefix_user u ON u.id = quiza.userid

WHERE 1=1

%%FILTER_COURSES:q.course%%
%%FILTER_ADVANCEDSQL01:q.id%%

--------------------------------------------------

*Setup the advanced filter:
SELECT id, name
FROM prefix_quiz