Well then that's a very different report. Try:
select
c.fullname as course_name,
q.name as quiz_name,
gi.gradepass,
gi.grademax
from prefix_quiz q
join prefix_course c on q.course = c.id
join prefix_grade_items gi on gi.courseid = c.id