Scenario
The HR department needs a complete faculty directory showing each faculty member's name and tenure status for the accreditation self-study.
Expected output
All 35 faculty members with their names and tenure status, sorted alphabetically by last name.
faculty_idfirst_namelast_nametenure_status_desc
Tables
ods_faculty ods_person
Hints
Hints are a Pro feature. Upgrade