Hello All,
I would like to ask your help for a SQL report.
I would like to create by SQL codes what is like as the standard quiz report :
(Quiz administration/Results/Grades)
http://yourmoodle.com/mod/quiz/report.php?id=yourquizID&mode=overview
But my required fields only:
- Name
- Email address
- Department (if it possible)
- Institution (if it possible)
- Quiz started date/time
- Quiz completed date/time
- Time taken
- Grade
Thank you for your advise
J. Somogyi
(Moodle: 3.0+, mysql)