Question: Construct and execute INSERT SQL statements to add the sample data in the following tables to the Customer and Address tables in the HandsOnOne database:
Construct and execute INSERT SQL statements to add the sample data in the following tables to the Customer and Address tables in the HandsOnOne database:
Additional Sample Data for Customer Table
| CustomerID | CustomerName | CustomerAddressID |
| 1 | Western Supply Company | 1 |
| 2 | Nick Harper | 3 |
| 3 | Alice Harper | 3 |
| 4 | Abacus Consulting | 4 |
Additional Sample Data for the Address Table
| AddressID | Street | City | State | Zip Code |
| 1 | 2400 Broadway Drive | Missoula | MT | 59802 |
| 2 | 320 21st Street | Billings | MT | 59101 |
| 3 | 439 Skyline Blvd | Denver | CO | 80002 |
| 4 | 56 Park Avenue | New York | NY | 10001 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
