Dear all,
How can we use sql language to search the grade of each students by course ? We can use sql language as shown as below:
SELECT a.firstname, FROM_UNIXTIME( b.timefinish ) , b.sumgrades, c.name
FROM mdl_user a, mdl_quiz_attempts b, mdl_quiz c
WHERE a.id = b.userid
AND c.id = b.quiz
or
SELECT
mdl_grade_items.itemname,
ROUND(mdl_grade_grades.finalgrade, 0) AS finalgrade,
mdl_user.firstname,
from_unixtime(mdl_grade_grades.timemodified)
FROM
mdl_grade_grades
INNER JOIN mdl_user ON mdl_grade_grades.userid = mdl_user.id
INNER JOIN mdl_grade_items ON mdl_grade_grades.itemid = mdl_grade_items.id
WHERE (mdl_grade_items.itemname IS NOT NULL)
AND (mdl_grade_items.itemtype = 'mod' OR mdl_grade_items.itemtype = 'manual')
AND (mdl_grade_items.itemmodule = 'quiz' OR mdl_grade_items.itemmodule IS NULL)
AND (mdl_grade_grades.timemodified IS NOT NULL)
AND (mdl_grade_grades.finalgrade > 0)
AND (mdl_user.deleted = 0)
But we can not know it's course name , how can we add course name in sql language ? Thanks a lot.