Scenario
A prospective student wants to see all active undergraduate degree programs the university offers, including the type of degree (BA, BS, etc.).
Expected output
All active undergraduate programs with degree type, sorted alphabetically by title.
acad_programs_idacpg_titleacpg_degreeacpg_degree_desc
Tables
ods_acad_programs
Hints
Hints are a Pro feature. Upgrade