Write a query to display list of department names and number of students in that department, if student exist. Give an alias to the count as student_count. Sort the record based on department name.

Question

Could someone help me in writing a query to display a list of department names and the number of students of students in that department, if students exist? Give an alias to the count as student_count. Sort the record based on the department name.