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