All pastes #100999 Raw Edit

Someone

public text v1 · immutable
#100999 ·published 2006-07-26 16:42 UTC
rendered paste body
SELECT AVG(COUNT(employee_id)) "Average Employees per Manager",
       MIN((SELECT AVG(salary)
              FROM employees
              WHERE manager_id IS NOT NULL)) "Average Salary of Employees"
FROM employees
WHERE manager_id IS NOT NULL
GROUP BY manager_id