Hi There,
I'm struggling to work out the SQL statement for a query I need. I want to work out how far through a course a user is. Sort of % completion.
I know where to find the information on all the resources on the course:
SELECT COUNT(l.id) COUNT, l.course, c.fullname coursename
FROM prefix_resource l INNER JOIN prefix_course c ON l.course = c.id
GROUP BY course
ORDER BY COUNT DESC
But where does Moodle hide what has already been completed on a course?
Cheers
Dave