Question 1: INSERT 200 CUSTOMERS INTO YOUR CUSTOMER TABLE USING THE INSERT SQL STATEMENT Question 2:...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

Answer Question 1 To insert 200 customers into your CUSTOMER table using the INSERT SQL statement yo... View the full answer