Hello everyone,
I am pretty new to SQL queries. Wondering if anyone could lend a hand... I recently edited one of the built-in queries in Configurable Reports to look as follows:
SELECT
u.username AS 'Passport Number',
u.firstname AS 'First Name' ,
u.lastname AS 'Last Name',
u.country AS 'Country',
c.fullname AS 'Course full name',
c.shortname AS 'Course short name',
c.idnumber AS 'Course ID',
cc.name AS 'Category',
ccp.name AS 'Cohort',
CASE
WHEN gi.itemtype = 'course'
THEN CONCAT(c.fullname, '- Final Grade ')
ELSE gi.itemname
END AS 'Assignment',
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
JOIN prefix_course_categories AS ccp ON (cc.parent = ccp.id) WHERE gi.courseid = c.id
ORDER BY lastname
My question is- how would I add a column that will show the manager for each course?
Thanks!