Scenario
Academic Affairs wants the average GPA and average cumulative credit hours by academic program to identify programs that may need additional academic support resources.
Expected output
One row per academic program with avg_gpa (average stpr_gpa, rounded to 3 decimal places), avg_credits (average stpr_cum_credits, rounded to 1 decimal place) and student_count, sorted by average GPA ascending.
sttr_acad_programavg_gpaavg_creditsstudent_count
Tables
ods_stu_acad_levels
Hints
Hints are a Pro feature. Upgrade