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.