Hey Alex,
I don't want the mark scored by the users in a quiz, I want the total marks of the quiz and the course that those marks are from.
So I need to have the course id and the average quiz marks from that course.
Then your query seems to be correct to me so far but i have not tested it yet .
Alright, I'll have to make some more tests to check if it's correct.
Thank you so much for the help, Alex!