M02

Average Financial Aid Package

MediumFinancial Aid25 pts
Related lesson: GROUP BY & HAVING

Scenario

The Financial Aid Director wants to compare the average grants, loans, and unmet need by aid year to assess whether aid packaging is keeping pace with costs.

Expected output

Three rows (one per aid year) with rounded averages for grants, loans, and unmet need, sorted by aid year ascending.

fa_yearavg_grantsavg_loansavg_unmet_need

Tables

ods_financial_aid

Hints

Hints are a Pro feature. Upgrade