Write a SQL query to find the top 5 students by total completed credits within each program.
Use the provided student, program, and course completion data. Include only completed credits, and include enrolled students whose completed-credit total is zero.
Output
- One row per selected student
- Columns:
program_name, student_id, student_name, and total_completed_credits
- Return no more than five students per program
- Order by
program_name, total completed credits descending, then student_id ascending for ties
