Hi,
Extremely new to SQL but loving it so far and many thanks to the SQL AD Hoc contributions.
What I would like to know:
Situation: Have 12 courses in three categories and want a report on users and their scores on a select few quizzes, not all quizzes.
Is this possible to achieve through an SQL query?
Ideally the data we could get back would be
Category / First Name / Last Name / Course /Group / Attendance / Quiz 1/ Quiz 2 / Quiz 3 /....Quiz X.
Any thoughts or hints would be great.