A retail company wants to update the customers table so that…
A retail company wants to update the customers table so that the customer with customer_id = 1005 has their country changed to Canada. Which SQL is correct? UPDATE customers SET country = ‘Canada’ WHERE customer_id = 1005; UPDATE customers country = ‘Canada’ WHERE customer_id = 1005; UPDATE customers VALUES (country = ‘Canada’) WHERE customer_id = 1005; MODIFY customers SET country = ‘Canada’ WHERE customer_id = 1005; Answer: UPDATE customers SET country = ‘Canada’ WHERE customer_id = 1005; Explanation: The correct syntax is UPDATE table_name SET column = value WHERE condition. The other options misuse keywords or syntax.