SQL Report - Activities within Courses

Re: SQL Report - Activities within Courses

by Kelly Thomas -
Number of replies: 0

Believe it or not, I figured out how to do this in "Configurable_Reports". Here's what it looks like:

SELECT prefix_course.shortname Name, prefix_quiz.name Quiz,

Count(prefix_quiz_attempts.attempt) Count

FROM prefix_course prefix_course, prefix_quiz prefix_quiz, prefix_quiz_attempts prefix_quiz_attempts

WHERE prefix_course.id = prefix_quiz.course AND prefix_quiz.id = prefix_quiz_attempts.quiz

GROUP BY prefix_quiz.name, prefix_course.shortname ORDER BY prefix_course.shortname

Just in case anybody else needs it someday...

Average of ratings: Useful (1)