tcs mysql hands_on Answer 2020

select deptname,count(*) from Departments inner join Employees 
on Employees.deptId = Departments.deptId
group by Departments.deptId
order by Departments.deptName;