Introduction
4. Table flight
Dates
Time
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

Instruction

The last table we'll work with is flight. Let's check it.

Exercise

Select all the information for the table flight.

This table lists specific flights (id) on a specific route (route_code) with a specific aircraft (aircraft_id) on a specific date (date).

The delay column is expressed in minutes. A positive value in this column means that the arrival was indeed delayed. A negative value indicates that the plane landed ahead of schedule.

Console

Code editor

Result

TableConsole