Write a query to display each department's name, location (Name of the City), number of employees, and the average salary for all employees in that department. Label the columns Name, Location, Number...

Extracted text: Write a query to display each department's name, location (Name of the City), number of employees, and the average salary for all employees in that department. Label the columns Name, Location, Number of People, and Salary, respectively. Round the average salary to two decimal places. Name Location Number of People Salary Administration Seattle 4400.00 Marketing Toronto 2 9500.00 Shipping South San Francisco 5 3500.00 IT Southlake 3 6400.00 Sales Oxford 3 10033.33 Executive Seattle 4 24875.00 Accounting Seattle 10150.00 Contracting Seattle NULL