</>CodeChallenge

Lessons Roadmaps Practice Playground AI Tutor

Search lessons

CodeChallenge — learn coding one step at a time.

Create at © Oct 13, 2026 by Kouch Lyhour

Lessons Roadmaps Playground Search

AI tutor

Ask about any programming topic

You can ask 3 free questions a day. Log in for 20 a day.

Ask anything about programming. Try:

The tutor can make mistakes, so check important answers. Your questions are sent to an AI service to answer them.

Your question

3 of 3 left today

Exercise: Average score per course · CodeChallenge

Practice
SQL

Average score per course

JOIN two tables and calculate each course's average score.

intermediateSQL

The task

Show every course that has enrollments, with its average score rounded to 1 decimal.

Columns: the course title, then the average score
Join courses with enrollments (enrollments.course_id points to courses.id)
Best average first

Your output should be:

React 88
JavaScript 85
HTML & CSS 83.3

Next exercise: Best student in each course →

Log in to save your progress and earn 25 points for each exercise.

Hints

Solution

Try it yourself first: you learn the most from getting stuck and finding the way out.