Câu 3: 1D0-541: CIW v5 Database Design Specialist

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?

1. A. DELETE * FROM Customers WHERE Sales_Office = New York;
2. B. DELETE FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York? — đáp án hiện tại
3. C. DELETE * FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
4. D. DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?