Departments

Report a typo

There are several departments in some company, information about which is stored in the departments table. The table has such columns as name (of department) and employees_n (number of employees).

Write a query that groups departments by name, finds the average number of employees for each department, and outputs this information. Also, order the output by the average number of employees.

Write an SQL statement





Create a free account to access the full topic