Average Progress of Non-Completers

Return the average progress (rounded to 2 decimals) of enrollments that are not completed, per course. Order by course.

Table schema

Enrollments(id INT PRIMARY KEY, student VARCHAR(10), course VARCHAR(10), progress INT, completed INT)

Sample data

id | student | course | progress | completed
1 | Ann | SQL | 100 | 1
2 | Bob | SQL | 40 | 0
3 | Cy | SQL | 100 | 1
4 | Ann | Python | 60 | 0
5 | Dee | Python | 100 | 1
6 | Eli | Python | 10 | 0
7 | Fay | Python | 0 | 0