Question

A sales analyst needs to view only the customer records where the Country column equals 'Canada' from an Azure SQL Database table named Customers. Which SQL statement should the analyst use?

Accepted Answer

SELECT * FROM Customers WHERE Country = 'Canada';

Answer

UPDATE Customers SET Country = 'Canada';

Answer

INSERT INTO Customers (Country) VALUES ('Canada');

Answer

DELETE FROM Customers WHERE Country = 'Canada';