Home Online Database ERD Activity 1 Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Activity 7

Activity 1: Simple queries: Selecting and sorting data from one table.

Investigate

First start by learning about the SQL SELECT statement by reading through the following web pages:

Practice

Use the Online Database to perform the following queries:

DescriptionSQL QueryResults
Select all customers from the UK
Select all customers from the UK sorted by city
Select the firstname, lastname and date of birth of Mrs Callahan (Employees Table)
Select all the suppliers sorted per country
List all the products available for less than £20
List all the products in descending order of price