I am trying to get the number of participants passing in quiz greater than equal to 7.
The following query will ouput the results of sumgrade above 7 and equal but i checked in report of quiz attempt passed in browser. cant get the real results. Where to get the user quiz grade table. please help me to get it
select mdl_user.username,mdl_user.email from mdl_quiz_attempts, mdl_user
where mdl_quiz_attempts.sumgrades >=7 and mdl_quiz_attempts.quiz =3 and state='finished'
and mdl_user.id = mdl_quiz_attempts.userid and mdl_user.deleted =0