If the airport staff want to know which gates of a certain size are available, the software will need to run a query producing a result set showing which gates are currently available and what type they are. As an added challenge, the staff also need to know if the gate is a standard size or for a large aircraft.

The query needs to be for a certain size of gate. In the example shown here, the query was to find available spots that were larger than 625 sqm of area:

g_id	type
3	standard
5	standard
6	large craft

The type of column in the output is based on the area field. The area value is stored as an integer but we want the words “Standard” or “Large Craft” to appear. For this you will need to search online for how to use an “inline if” statement.