create table new_department select*from department; insert into new_department values('D004','営業部','12'); insert into new_department('dep_id','name','floor') values('D005','経理部','8'); update new_department set name='山田太郎'where emp_id='E00001';  update new_department set salary = salary * 0.7 where gender='女';