Question $4$: Analyzing Course Enrollments with ROLLUP $(1$Point$)$

The university administration is interested in analyzing course enrollment trends across different departments over the years. This analysis is crucial for resource allocation, planning future course offerings, and understanding departmental growth.

Your task is to use the SQL ROLLUP function to generate a report that shows the total number of enrollments per department, broken down by year, along with subtotal numbers per department and a grand total number across all departments.

Deliverables

Submit the SQL query that generates a report using rollup.