count(designation="); sql code example

Example: Write a query to print every Department Name and the count of employees in that department.

Write a query to print every Department Name and the count of employees in that department.