drop table copy_emp;
create table copy_emp as
select * from employees;
update copy_emp
set salary =24100, department_id = 10
where employee_id = 100;
update copy_emp
set department_id = null
where employee_id = 100;
select * from copy_emp
where employee_id = 100;