My way to find out the final grade of student is this:
SELECT g.id itemid, z.finalgrade, u.firstname, u.lastname, c.shortname, u.id userid
FROM mdl_course c, mdl_grade_items g, mdl_user u, mdl_grade_grades z
WHERE c.id = g.courseid
AND g.itemtype = 'course'
AND c.visible = '1'
AND g.id = z.itemid
AND u.id = z.userid
AND u.deleted != '1'
ORDER BY u.firstname
LIMIT 0 , 30
Is there another way to query the final grade with less movements or a better way to figure it out?