SQL Quiz 3

Insert the missing statement to get all the columns from the Customers table.

___________* FROM Customers;

Write a statement that will select the City column from the Customers table.

_______ ____ ______ Customers;

Select all the different values from the Country column in the Customers table.

_______ _________ Country FROM Customers;

Select all records where the City column has the value "Berlin".

SELECT * FROM Customers _____ ____ = ________;

Use the NOT keyword to select all records where City is NOT "Berlin".

SELECT * FROM Customers _____ ___ ____ = "______";

Select all records where the CustomerID column has the value 32.

SELECT * FROM Customers _____ CustomerID __ __;

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 all records where the City column has the value 'Berlin' or 'London'.

______ * FROM Customers _____ City = 'Berlin' __ ____= '______';

Insert a new record in the Customers table.

______ ____ Customers CustomerName, Address, City, PostalCode,

Country _ _____ _ 'Hekkan Burger', 'Gateveien 15', 'Sandnes', '4306', 'Norway' _ ;

Update the City column of all records in the Customers table.

______ Customers ___ City = 'Oslo';