Good day Shea,
This query would be really helpful. We make use of the lesson activity for our online courses here at the University of Namibia. I am however not able to help with your query above as I am not yet competent enough in SQL.
Hope you find a solution.