Question

Write an SQL query to show all departments along with

the number of people in there.​

Answer 1

Answer:

Write an SQL query to fetch the count of employees working in the department 'Admin'. Ans. The required query is: SELECT COUNT(*) FROM worker WHERE DEPARTMENT = 'Admin';