Moodle SQL: All attempt steps in a quiz - not just the last for each student

attempt-steps.sql

SELECT 
  qa.*, 
  qas_last.*, 
  qas_last.timecreated AS stepdate,
  u.email, 
  u.firstname, 
  u.lastname 
FROM {course_modules} cm
JOIN {quiz_attempts} quiza ON quiza.quiz = cm.instance
JOIN {question_usages} qu ON qu.id = quiza.uniqueid
JOIN {question_attempts} qa ON qa.questionusageid = qu.id
  LEFT JOIN {question_attempt_steps} qas_last ON qas_last.questionattemptid = qa.id 
  LEFT JOIN {user} u ON qas_last.userid = u.id 
WHERE 
  cm.id = :quiz_id
ORDER BY 
  u.username, 
  qas_last.timecreated