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

Question

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

Quizplus · Accepted Answer

The Answer of 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

Consider the Relations Shown in the Exhibit