Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Answer Question 1 To insert 200 customers into your CUSTOMER table using the INSERT SQL statement yo...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started