Question: 1 . Create a new table named COPY _ FROM _ OWNERS based on the structure of the OWNER table. 2 . Insert a new

1. Create a new table named COPY_FROM_OWNERS based on the structure of the OWNER table.
2. Insert a new record into the COPY_FROM_OWNERS table with the following details: OWNER_NUM: JO111 LAST_NAME: Johnson FIRST_NAME: Alex ADDRESS: 1234 Elm St. CITY: Seattle STATE: WA ZIP_CODE: 98122
3. Update the address of the record with OWNER_NUM 'JO111' in the COPY_FROM_OWNERS table to '5678 Oak St.'.
4. Add a new column named PHONE_NUMBER to the COPY_FROM_OWNERS table.
5. Update the PHONE_NUMBER of the record with OWNER_NUM 'JO111' to '555-6789'.
6. Delete the record with OWNER_NUM 'JO111' from the COPY_FROM_OWNERS table.
7. Create a new table named NEW_OWNERS with the following columns: OWNER_NUM, LAST_NAME, FIRST_NAME, EMAIL
8. Insert a new record into the NEW_OWNERS table with the following details: OWNER_NUM: MO112 LAST_NAME: Moore FIRST_NAME: Jamie EMAIL: jamie.moore@example.com
9. Insert records from the COPY_FROM_OWNERS table into the NEW_OWNERS table for entries with STATE 'WA'.
10. Drop the COPY_FROM_OWNERS table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!