M07

Scenario

The Academic Affairs committee wants to see the overall grade distribution across all course enrollments to assess grade inflation.

Expected output

One row per grade letter showing grade_count and pct_of_total — its share of all graded enrollments as a percentage rounded to 1 decimal place. Ungraded enrollments (NULL grade) are left out. Sorted by count descending.

scs_verified_gradegrade_countpct_of_total

Tables

ods_stu_course_sec

Hints

Hints are a Pro feature. Upgrade