8일차 # 4-23: Nesting Group Functions

- nested to a depth of two. 

  select max(avg(salary))

  from employees

  group by department_id;

  select department_id, max(avg(salary))

  from employees

  group by department_id;