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

Activity 2: Complex queries: Selecting data from one table using a range of filtering criteria

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 or from Germany
Select all customers from the UK but not based in London
Select all suppliers from North America (Canada or USA) sorted by supplier name
Select all products between £20 and £40.