CODE EXAMPLE FOR SQL

moodle query item quiz

SELECT cm.id, q.name
FROM mdl_quiz AS q
INNER JOIN mdl_course_modules AS cm
ON q.id = cm.instance