Average Grade, Rounded

What is the average grade across all enrollments that have one? Return one row with graded (how many enrollments have a non-NULL grade, via COUNT(grade)) and avg_grade (the average grade, rounded to 2 decimal places). AVG ignores NULL grades on its own, so the in-progress and dropped rows need no filter.

Expected result:

+--------+-----------+
| graded | avg_grade |
+--------+-----------+
|     52 |     77.19 |
+--------+-----------+
1 row

Hints3 available

Topics:

Aggregates & GROUP BY

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.