Write a SQL query to find the top five courses with the highest enrollment.
Use the provided courses and enrollments tables. Return courses even when they have no enrollments, although zero-enrollment courses should not appear in the top five.
course_id, course_code, course_name, and enrollment_countenrollment_count descending, then course_id ascending for ties| Column | Type | Description |
|---|---|---|
| course_idPK | INT | Unique course identifier |
| course_code | VARCHAR(20) | Catalog code for the course |
| course_name | VARCHAR(150) | Course title |
| department_name | VARCHAR(100) | Academic department offering the course |
| Column | Type | Description |
|---|---|---|
| enrollment_idPK | INT | Unique enrollment identifier |
| course_id | INT | Referenced course identifier |
| student_id | VARCHAR(20) | Student identifier |
| enrolled_at | DATE | Date the student enrolled |