Write the commands using SQL Developer following the instructions below. Copy and paste your query code into the submission box. This assignment should be completed by July 25th..

Create a table called EMPLOYEES with the following column. (If you already have an EMPLOYEES table, drop it.)

SSN, a number with 9 digits

lastname, to hold text up to 25 characters in length

firstname, to hold text up to 25 characters in length

MI, a fixed length single character

hiredate, a date with a default value of SYSDATE

address, to hold text up to 24 characters in length

city, to hold text up to 20 characters and a default value of 'Columbia'

state, a fixed length character field with two characters with a default value of 'SC'

zip, a number with 5 digits

Drop the column MI from the EMPLOYEES table

Add a column middlename to the EMPLOYEES table with the same data type as firstname

Create a table called WRITERS with the first and last names of the authors and the titles of the books they wrote. Get the data for the table from the existing tables in the database.

Delete the table WRITERS from the database permanently.