Consider the relation shown in the exhibit. 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?
The correct SQL statement to remove all tuples for New York customers should be properly formatted and use the correct SQL syntax. The correct statement is "DELETE FROM Customers WHERE Sales_Office = 'New York';" which matches option B when corrected for display errors. This ensures that all rows with 'New York' in the Sales_Office column are deleted.
B is the correct answer; however, the possible answers do not display properly. A. DELETE * FROM Customers WHERE Sales_Office = New York; B. DELETE FROM Customers WHERE Sales_Office = New York; C. DELETE * FROM Customer WHERE Sales_Office <> New York; D. DELETE FROM Customers WHERE Sales_Office NOT LIKE New York;