Here is the design for a query that will return all sports areas with a HireCost less than £50 and which are available to hire. For this example, let’s assume that the person hiring can spend £50.

It is important to take time to design any queries that may need to be implemented later. Query design does not need to include specific SQL (Structured Query Language) commands. SQL will only be ...