I am working with the following query:
SELECT XYZQuiz.Name AS 'Course', COUNT(*) AS 'Total Courses Completed'
FROM XYZQuiz INNER JOIN
XYZQuizUserLog ON XYZQuiz.QuizID = XYZQuizUserLog.QuizID INNER JOIN
XYZUser ON XYZQuizUserLog.UserID = XYZUser.UserId
WHERE need some help here
GROUP BY XYZQuiz.Name
My objective is to get the Total Number of courses completed (only reporting each course once per userID).
Would appreciate any help at all.