I would like to use the report described at http://docs.moodle.org/22/en/ad-hoc_contributed_reports#Site-Wide_Grade_Report_with_Just_Course_Totals
As written, this query errors out in my Moodle. I have tried tweaking it with no success. Is there a query that would produce the same results for Moodle 1.9 and MySQL?
The Global Grades report plugin works well but unfortunately doesn't give the course title in the final mark column, so requires a lot of manipulation in Excel every time it is run.