SQL query to get student enrolled in this month in a course - Moodle

33 views Asked by At

I am trying to get the total students who have enrolled in a particular course, with a course id, in this month only. The table structure is same as what remains in most of the Moodle databases.

I dont want the total of students of all time, I just want to get them in this month.

The code can be something related to those provided on this page: SQL query for Courses Enrolment on Moodle

The above link provides similar codes but does not include the date part which I want.

You can suggest me any other way also like using external webservices on moodle if this function exists there.

0

There are 0 answers