Answers for "Write an SQL query to fetch the no. of workers for each department in the descending order."

Write an SQL query to fetch the no. of workers for each department in the descending order.

SELECT DEPARTMENT, count(WORKER_ID) No_Of_Workers 
FROM worker 
GROUP BY DEPARTMENT 
ORDER BY No_Of_Workers DESC;

Posted by: Guest on July-26-2021

Code answers related to "Write an SQL query to fetch the no. of workers for each department in the descending order."