SQL query: Assignment Forum Quiz

SQL query: Assignment Forum Quiz

by Franz Flores -
Number of replies: 2

Hi guys,

I want to create a SQL query that let's me easily find:

1) How many quiz with zero (0) or 1 (one) there are in a course. (by each weekend) (total 5 sessions)

2) Select the value of the grade of: Assignment, Forum and Quiz by each weekend (total 5 sessions)

Do you have any suggestions on what tables I need to touch on to make this happen?

Thank you!

Average of ratings: -
In reply to Franz Flores

Re: SQL query: Assignment Forum Quiz

by Alan Hare -
  • Is this a SCORM or Moodle course?
  • What do you mean "How many quiz with zero (0) or 1 (one) there are in a course" ?
Average of ratings: -
In reply to Alan Hare

Re: SQL query: Assignment Forum Quiz

by Franz Flores -

hi Alan,

*) It´s a moodle course

*)  this is from 1 week

Average of ratings: -