1:select distinct department_id from employees;
2:select distinct department_id from employees where department_id is not null;
3:select distinct department_id from employees
where department_id not in(100);
4:select distinct department_id from employees
where department_id is not null and department_id not in(100);