I wish to get the information of accesses from my students, divided by weeks(based on duration of the course).
Course 1-> start_date = 01, Jan. | Course 1-> end_date = 31, March
So we have 12 weeks. For each user we would have a access count for that respective week.
Any ideas on how to build a query like this? I'm doing to use ML on some of my moodle courses.