Average Score Per Course

Problem

Write a query that returns each course's name and the average score students earned in it (aliased as average_score), by joining grades to courses and grouping by course. Order the results by average_score from highest to lowest.

Try It

Hint

Solution