Consider the Relations Shown in the Exhibit

Multiple Choice

Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

A) INSERT INTO Atlanta_Customers VALUES( SELECT * FROM Customer s WHERE Sales_Office = Atlanta
B) SELECT * FROM Customers WHERE Sales_Office = Atlanta
C) INSERT INTO Atlanta_Customers SELECT Cust_No, Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers
D) Cust_Name, Sales_Office, Sales_Rep_No FROM Customers