In this assignment, you only need to copy and paste the statements from SQL developer or SQLPlus. Note: You run the following three sql statements ONCE each (ignore error messages) before you perform the tasks in the order they appear.

CREATE TABLE regions as select * from hr.regions;

CREATE TABLE locations as select * from hr.locations;

CREATE TABLE departments as select * from hr.departments;

Recreate the Departments table in your account based on hr.departments table. However, your Departments table only has the data for the departments with the department names ending with ion or Sales.