Course Load Check

Academic advising at Fairhaven University keeps an eye on how much each student has taken on. Too heavy a load and the marks slide; too light and a student quietly falls behind on credits and finds out in their final year. The advisors want a workload sheet: each student and how many sittings they have on record across every term.

A sitting counts as work whether or not a mark has come back for it yet — the teaching happened either way. A student with nothing on record has no workload to review and is not on the sheet.

enrollments — one row per sitting: one student taking one course in one term. student_id points at a row in students and course_id at a row in courses. grade is the mark for that sitting, on the same 0-4 scale, and is NULL when no mark has been entered yet. semester is the term the sitting belongs to.

students — one row per enrolled student. gpa is the grade point average already on file for that student, on a 0-4 scale.

Both tables already exist in the database — there is nothing to create or load.

Task: Write a query that returns one row per student who has at least one sitting on record, with their name and how many sittings they have as courses_taken. Heaviest load first; if two students have the same number, the one whose name comes first alphabetically goes above the other.

Example output

Shape only — these students and counts are invented: