Which of the following SQL statements would properly remove all tuples for New York customers?

Consider the relation shown in the exhibit.

Which of the following SQL statements would properly remove all tuples for New York customers?

A.
DELETE * FROM Customers
WHERE Sales_Office = New York;

B.
DELETE FROM Customers WHERESales_Office = ew
York?WHERE Sales_Office = ?ew York?

C.
DELETE * FROM Customers WHERESales_Office = ew
York?WHERE Sales_Office = ?ew York?

D.
DELETE FROM Customers WHERESales_Office NOT LIKE ew York? WHERE Sales_Office
NOT LIKE ?ew York?