Progress: $81\mathrm{.}82\%$

Query: $09$ Total Credits per Course

Solution dataset

SQL: SELECT Courses.courseName, SUM$($Courses$.$credits $*$ Enrolls.enrollkey$)$ AS Total$\_$credits

Expected column names:

FROM Courses, Sections, Enrolls courseName, AS Total credits

WHERE Courses.courseKey $=$ Sections.courseKey

AND Enrolls.sectionKey $=$ Sections.sectionKey

GROUP BY Courses.courseName

For reference, here is a list of all ORDER BY Total$\_$credits DESC; tables and attributes:

Courses: courseKey, courseName, department, credits

Enrolls: enrollKey, sectionKey$,$

List the total credits awarded for each course $($credit hours for the course multiplied by COUNT of enrollkey$).$ Order by total credits descending.

Feedback for this query:

Too few parameters. Expected $1.$

Note, when the error message gives you an indication of 'too few parameters' it typically indicates that you have included an attribute $($or table name$)$ in your SQL that does not exist in your dataset. You should always verify the names of attributes$/$tables when getting this type of error.

Overall assignment feedback:

Finished? Submit the assignment

The following $2$ queries need to be addressed:

$09$ Total Credits per Course

$10$ Courses by Gender