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.

Example 1 - Availability query Here is the design for a query that should return all sports areas that are available for use. The areas' names should be listed in ascending order.