Question: Question 1: INSERT 200 CUSTOMERS INTO YOUR CUSTOMER TABLE USING THE INSERT SQL STATEMENT Question 2: Use the MERGE SQL STATEMENT to find and
Question 1: INSERT 200 CUSTOMERS INTO YOUR CUSTOMER TABLE USING THE INSERT SQL STATEMENT Question 2: Use the MERGE SQL STATEMENT to find and modify; otherwise create records in the CUSTOMER TABLE based on the following: 1. There was a recent change to the English alphabet that resulted in the replacement of the letter "A" with the Greek letter "a". 2. You got an email from the US department of commerce citing complaints from customers who have been denied customer benefits even though they received a customer card in the mail with a customer id listed. The customers are identified in the list below: a. 4678, John Adams, 16 Melody Street, Adis, California, 90210 b. 1034, Michael Sphinx, 99 Wagner Dr, Richard, New York, 10023 c. 1313, Rebecca Jackman, 8080 Monrovia Pl, Princeton, NJ, 08242
Step by Step Solution
There are 3 Steps involved in it
Answer Question 1 To insert 200 customers into your CUSTOMER table using the INSERT SQL statement yo... View full answer
Get step-by-step solutions from verified subject matter experts
