B: Querying a Database

Sports Database

The power of databases is creating complex queries to find specific information

In this lesson your will be querying a sports database to find suitable sports to join

How to Query a Database

Find all the records where sports = tennis and sort ascending

 

Find all the records where age group is Junior and category is fitness

 

Find all the records where the cost is less than £20

 

Find all the records where the duration is more than 5 weeks

 

Find all the records for adults on Saturday that cost less than £20

EXTENSION

Make 5 more queries about the data