There are many sample queries here:
https://docs.moodle.org/32/en/ad-hoc_contributed_reports
One of these examples may help you.
Analytics and reporting
Teacher and Student usage report
This discussion has been locked so you can no longer reply to it.