Write a SQL query to identify students who are enrolled in multiple departments but have not yet declared a major at Rutgers University.
Use the provided student, enrollment, department, and declared-major data. Treat multiple departments as distinct departments, regardless of repeated enrollment records.
Output
- One row per qualifying student with
student_id, student_name, department_count, and department_names.
- Include only students enrolled in at least two distinct departments and absent from the declared-major table.
- Sort by
student_id ascending.
