Scenario
The Admissions Office is preparing merit scholarship letters for the incoming class and needs the five incoming students with the highest high school GPA. High school GPA is recorded on the application, in dbo.ods_applications.appl_hs_gpa, not on the student record. An applicant counts as "incoming" once they have committed to attend, which in this data means appl_current_status is 'DP' (Deposited) or 'MS' (Move to Student) — applicants still sitting at 'AC' (Accepted) have been admitted but have not committed, and 'DN', 'WD' and 'NEW' are not incoming students at all. Pull the applicant's name from dbo.ods_person by joining on p.id = a.appl_applicant. Be careful: not every applicant has a high school GPA on file — transfer and non-traditional applicants apply with college transcripts instead — and in PostgreSQL a NULL sorts BEFORE every real value under ORDER BY ... DESC, so an unguarded top-5 would return nothing but empty rows. Alias appl_applicant as students_id.
Expected output
Exactly 5 rows, the five highest high school GPAs among incoming students (appl_current_status IN ('DP','MS')), sorted by appl_hs_gpa descending. Columns: students_id (aliased from appl_applicant), student_name (first_name || ' ' || last_name from ods_person), and appl_hs_gpa. Rows 5, 6 and 7 all tie at 3.79, so break the tie by appl_applicant ascending to make the fifth row deterministic.