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