🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 74:

Index for the Departures Board

PostgreSQL
The departures board of every airport runs this query hundreds of times a minute:

SELECT flight_no, scheduled_departure, arrival_airport, status
FROM flights
WHERE departure_airport = 'SVO'
  AND scheduled_departure BETWEEN '2017-08-15 06:00' AND '2017-08-15 12:00'
ORDER BY scheduled_departure;

The flights table has no indexes yet. Create one index that serves both conditions of this query and its sorting.
Expected result Columns: 2 · Rows: 1
indexed_columns index_method

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query