Average grade, ungraded excluded

SQLMedium12 min

Your task

Return each course with its average grade as title and avg_grade, rounded to a whole number, ignoring enrolments with no grade yet. Courses where nobody has a grade do not appear. Order by title.

Tables

student
idINTEGERnameTEXTyearINTEGER
1Tam1
2Uli2
3Vic2
4Wren3
course
idINTEGERtitleTEXTcreditsINTEGER
1Databases4
2Networks3
3Compilers4
4Ethics2
enrolment
student_idINTEGERcourse_idINTEGERgradeINTEGER
1188
1272
2191
2364
3191
3255
More rows not shown