Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?
Consider The Re 1 (149.09 KiB) Viewed 88 times
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 York?WHERE Sales_Office = ?ew York?
D. DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!