9일차 # 6-11: Having clause

Having clause

  

select department_id, min(salary)

from employees

group by department_id;

↓ ↓ ↓

select department_id, min(salary)

from employees

group by department_id

having min(salary) > (select min(salary)

                     from employees

                     where department_id = 20);