Useful SQL Queries?

Re: Useful SQL Queries?

by Paa Kwesi -
Number of replies: 1

Thanks Davies for the useful queries, 

Can you help me with a query that would display 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). 


Thanks in advance guys..


In reply to Paa Kwesi

Re: Useful SQL Queries?

by Paa Kwesi -

Thanks guys for the useful queries, very helpful..


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...