🙏 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 62:

Display a table of departures

PostgreSQL
Display a table of departures from Sheremetyevo airport SVO for August 12, 2017 with columns flight_no, arrival_airport, < span class='sql'>actual_departure, time_after_previous_flight - time elapsed since the departure of the previous flight, sorted by departure time.
Expected result Columns: 4 · Rows: 50
flight_no arrival_airport actual_departure time_after_previous_flight

Sample rows open after wrong checks: 0 of 2

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