Write a query to Drop table Customers!!! Here's what to write: Drop table Customers; $($if you do not

have a customers table, you can skip this step and move on to question $7).$

Now we'll recreate the customers table: Use fields customer#$,$ lastname, firstname, address,

city, state, zip, referred, region. Add Not null constraints to lastname and firstname.

Table Management

Rename the customer table as consumer

SQL$>$ alter table customer

$2$ rename to consumer;

Create a new table with these four columns from the existing customers table: Customer#$,$

City, and state. Name the new table Cus location.

Delete the Cus location table. Then restore the table Cus location. Be sure to write out both

queries syntax