Question: $3$ of $5$

Write an SQL query to find the total number of employees hired in each department in the year $2000.$

Display the department number, department name, and th corresponding count of employees.

The query should print three columns: "dept$\_$no$",$

"dept$\_$name", and "employee$\_$count".

The result should be ordered by the "dept$\_$no$"$ in ascending order.

This is a $"$MySQL Question". Only "Select $"$ from whereQueries" will work with this question. Do not use upDate, DELETE, etc.

Table schema

employees

emp$\_$no

date