Hi
How can I modify the standard Site-Wide Grade Report code below (also attached) to only pick grades below say 50?
SELECT u.username AS 'UserName', u.firstname AS 'Name' , u.lastname AS 'Surname', u.city AS City, u.email AS Email, c.fullname AS 'Course', cc.name AS 'Category', gi.itemname AS 'Item Name',
CASE
WHEN gi.itemtype = 'course'
THEN CONCAT(c.fullname, ' - Total')
ELSE gi.itemname
END AS 'Item Name',
ROUND(gg.finalgrade,2) AS Grade,
FROM_UNIXTIME(gg.timemodified) AS TIME
FROM prefix_course AS c
JOIN prefix_context AS ctx ON c.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories AS cc ON cc.id = c.category
WHERE gi.courseid = c.id
ORDER BY `UserName` ASC