Question

Write an SQL query to fetch the no. of workers for

each department in the descending order.​

Answer 1

Explanation:

You can use the COUNT(*) function in the ORDER BY clause to sort the number of rows per group. For example, the following statement gets the number of employees for each department and sorts the result set based on the number of employees in descending order.

Hope it's your helpfull.