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 INTOAtlanta_Customers
VALUES( SELECT * FROM
Customer s WHERE Sales_Office =
Atlanta
B.
INSERT INTOAtlanta_Customers
SELECT * FROM Customers
WHERE Sales_Office = Atlanta
C.
INSERT INTOAtlanta_Customers SELECT Cust_No,
Cust_Name, Satisfaction_Rate, Sales_Rep_No FROM Customers
WHERE Sales_Office = Atlanta
D.
INSERT INTOAtlanta_Customers SELECT Cust_No,
Cust_Name, Sales_Office, Sales_Rep_No FROM Customers
WHERE Sales_Office = Atlanta