Write a query based on the below records in the table
Empid Empname Dept1 Praveen IT2 Mahesh IT3 Scott HR4 Leslie Admin5 Mary HR
Write a SQL query which returns the following result
Dept No of Employees
IT 2HR 2Admin 1
select