Custom Reports Via SQL Queries

Custom Reports Via SQL Queries

by Paa Kwesi -
Number of replies: 1

Hi Moodlers,


I'm new to moodle and need help with some queries. Can any aid with some queries for the these:


1. number of students assigned to each content / module 


2. The total number of users that have the role 'student' in Moodle? 

Such that it is the sum of students in 'Course A' and 'Course B' up to 'Course Z' (assuming 'course Z' is the last course in the system).  


3. highest, average and lowest score attained under each module 


Thanks a lot in advance guys...


Average of ratings: -