SQL
Select all records where the City column has the value 'Berlin' and the PostalCode column has the value 12209. ________ * FROM Customers _______ City = 'Berlin' ____ __________ = 12209;
SELECT * FROM Customers WHERE City = 'Berlin' AND PostalCode = 12209;
Select all records where the City column has the value 'Berlin' or 'London'. _______ * FROM Customers _______ City = 'Berlin' __ ____ = '________';
SELECT * FROM Customers WHERE City = 'Berlin' OR City = 'London';
Select all records where the City column has the value "Berlin". SELECT * FROM Customers ________ ________ = '_________';
SELECT * FROM Customers WHERE City = 'Berlin';
Select all records where the CustomerID column has the value 32. SELECT * FROM Customers ________ CustomerID __ ___;
SELECT * FROM Customers WHERE CustomerID = 32;
Use the NOT keyword to select all records where City is NOT "Berlin". SELECT * FROM Customers ____________ = '_______';
SELECT * FROM Customers WHERE NOT City = 'Berlin';
Insert the missing statement to get all the columns from the Customers table. _______ * FROM CUstomers;
SELECT * FROM Customers;
Write a statement that will select the City column from the Customers table. ______ ______ _______ Customers;
SELECT City FROM Customers;
Select all the different values from the Country column in the Customers table. _________ ________ Country FROM Customers;
SELECT DISTINCT Country FROM Customers;