I want to get the
Total Number of Participants,
Number of Participants Passing,
Percentage % of Participants Passing,Average Score,
Average Time to Complete Lesson from each section from the courses.
How to build the mysql query to get it i am building this query to get it. Please add some more information to get it exact result
select c.fullname,COUNT(ue.id) AS Enroled,sections.name as Title from mdl_course_sections sections,mdl_quiz quiz, mdl_user_enrolments ue, mdl_enrol en, mdl_course AS c where quiz.course = sections.course and en.courseid = c.id