select deptname,count(*) from Departments inner join Employees
on Employees.deptId = Departments.deptId
group by Departments.deptId
order by Departments.deptName;
To see this working, head to your live site.
Search
Dec 7, 2020
· Edited: Dec 7, 2020 tcs mysql hands_on Answer 2020
tcs mysql hands_on Answer 2020
0 comments