Write script to do the following: Use create table statement to create new copy of the L_EMPLOYEES table, with a new name. Then use an insert statement with a select clause to copy all the data from the L_EMPLOYEES table to your new copy of the table.

Add a primary key to the sec0609_employeestable.

Write script to do the following: Add two new columns to the sec0611_departments table. One new column, a text column, will be for the name of the manager of the department. The other new column, a numeric column, is for the annual budget of the department.

Expand the length of the last_namecolumn to the sec0612_employeestable. Expand it to a length of 50 letters so people with hyphenated last names can be hired by the company.

Delete the phone_numbercolumn from a the sec0613_employeestable.

Eliminate the duplicate rows from the sec0616_duplicate_rows table.

Assign a number to each row of the sec0617_duplicate_rows table.