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 WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
C) DELETE * FROM Customers WHERE Sales_Office = ew
D) DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?

Question

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 WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York? 
C) DELETE * FROM Customers WHERE Sales_Office = ew 
D) DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?

Quizplus · Accepted Answer

The Answer of 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 WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York? 
C) DELETE * FROM Customers WHERE Sales_Office = ew 
D) DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?

Consider the Relation Shown in the Exhibit