Rank Departments by Student Count

Consider a university database with two tables: department and student. The department table has: dept_id: a unique identifier for the department dept_name: the display name of the department, which is not necessarily unique The student table has: student_id: a unique identifier for the student student_name gender dept_id: the department the student belongs to, referencing department.dept_id Every student is assigned to exactly one department. Compose a standard SQL query…