Thank you SO much! This query was a life saver!
(It is now saved under my SQL queries on my server; I make use of the Ad-hoc Database Queries plugin - https://moodle.org/plugins/view/report_customsql)
M Horn,
Could you share your ad-hoc query with the community. That plugin is very convenient and it seems like this happens more often than you would think.
- Michael H.