Question: 1 . Create a new table named COPY _ FROM _ OWNERS based on the structure of the OWNER table. 2 . Insert a new
Create a new table named COPYFROMOWNERS based on the structure of the OWNER table.
Insert a new record into the COPYFROMOWNERS table with the following details: OWNERNUM: JO LASTNAME: Johnson FIRSTNAME: Alex ADDRESS: Elm St CITY: Seattle STATE: WA ZIPCODE:
Update the address of the record with OWNERNUM JO in the COPYFROMOWNERS table to Oak St
Add a new column named PHONENUMBER to the COPYFROMOWNERS table.
Update the PHONENUMBER of the record with OWNERNUM JO to
Delete the record with OWNERNUM JO from the COPYFROMOWNERS table.
Create a new table named NEWOWNERS with the following columns: OWNERNUM, LASTNAME, FIRSTNAME, EMAIL
Insert a new record into the NEWOWNERS table with the following details: OWNERNUM: MO LASTNAME: Moore FIRSTNAME: Jamie EMAIL: jamie.moore@example.com
Insert records from the COPYFROMOWNERS table into the NEWOWNERS table for entries with STATE WA
Drop the COPYFROMOWNERS table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
