SQL Practicals

Question 1

Get all the columns from the Customers table.

Answer 1

SELECT * FROM Customers;

Question 2

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

Answer 2

SELECT City FROM Customers;

Question 3

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

Answer 3

SELECT DISTINCT Country FROM Customers;

Question 4

Select all the columns from the Customers table, then

Select all records where the City column has the value “Berlin”.

Answer 4

SELECT * FROM Customers WHERE City = ‘Berlin’;

Question 5

Select all the columns from the Customers table, then

use the NOT keyword to select all records where City is NOT “Berlin”

Answer 5

SELECT * FROM Customers WHERE NOT City = ‘Berlin’;

Question 6

Select all the columns from the Customers table, then select all records where the CustomerID column has the value 32.

Answer 6

SELECT * FROM Customers WHERE CustomerID = 32;

Question 7

Select all the columns from the Customers table, then select all records where the City column has the value ‘Berlin’ AND the PostalCode column has the value 12209.

Answer 7

SELECT * FROM Customers WHERE City = ‘Berlin’ AND PostalCode = 12209;

Question 8

Select all the columns from the Customers table, then select all records where the City column has the value ‘Berlin’ or ‘London’.

Answer 8

SELECT * FROM Customers WHERE City = ‘Berlin’ OR City = ‘London’;

Question 9

Select all the columns from the Customers table, then sort the result alphabetically by the column City.

Answer 9

SELECT * FROM Customers ORDER BY City;

Question 10

Select all the columns from the Customers table, then sort the result reversed alphabetically by the column City.

Answer 10

SELECT * FROM Customers ORDER BY City DESC;

Question 11

Select all the columns from the Customers table, then sort the results alphabetically, first by column Country, then, by the column City.

Answer 11

SELECT * FROM Customers ORDER BY Country, City;

Question 12

Insert a new record in the Customers table which includes CustomerName, Address, City, PostalCode, Country with the corresponding values of John Smith, 15 Wilson St, Detroit, 33303, USA.

Answer 12

INSERT INTO Customers ( CustomerName, Address, City, PostalCode, Country) VALUES ( John Smith, 15 Wilson St, Detroit, 33303, USA);

Question 13

Select all the columns from the Customers table where the PostalCode column is empty.

Answer 13

SELECT * FROM Customers WHERE PostalCode IS NULL;

Question 14

Select all the columns from the Customers table where the PostalCode is not empty.

Answer 14

SELECT * FROM Customers WHERE PostalCode IS NOT NULL;

Question 15

Update the City column of all records in the Customers table with the City ‘Oslo’.

Answer 15

UPDATE Customers SET City = ‘Oslo’;

Question 16

Update the City column in the Customers table to ‘Oslo’, but only the ones where the Country column has the value ‘Norway’

Answer 16

UPDATE Customers SET City = ‘Oslo’ WHERE Country = ‘Norway’;

Question 17

Update the City value and the Country value in the Customers table for all CustomerID that equal 32.

Answer 17

UPDATE Customers SET City = ‘Oslo’, Country = ‘Norway’ WHERE CustomerID = 32;