Hola a todos quien me pueda ayudar gracias - llevo varios dias tratando de realizar este reporte en SQL y siempre saca error primero era que faltaba una sentencia y despues no se puede realizar la consulta.
Trabajo sobre moodle 1.9
SELECT c.id AS quiz_id, c.course AS course_id, c.questions,
co.fullname AS course_fullname, co.shortname AS course_shortname,
c.name AS quiz_name, FROM_UNIXTIME(c.timeopen) AS quiz_timeopen, FROM_UNIXTIME(c.timeclose) AS quiz_timeclose,
u.firstname, u.lastname, u.email,
FROM prefix_quiz c, prefix_course co, prefix_role re, prefix_context ct, prefix_role_assignments ra, prefix_user u
WHERE FROM_UNIXTIME(timeopen) > '2011-05-14' AND
c.course = co.id AND
co.id = ct.instanceid AND
ra.roleid = re.id AND
re.name = 'Teacher' AND
ra.contextid = ct.id AND
ra.userid = u.id
SELECT Count('x') AS NumOfStudents
FROM prefix_role_assignments a
JOIN prefix_user u ON userid = u.id
WHERE roleid = 5 AND contextid = (SELECT id FROM prefix_context WHERE instanceid = 668 AND contextlevel = 50)
Gracias esto es lo que busco hacer - la idea es poder consultar todos los estudiantes, Curso y solo la calificacion en los custionarios o quiz