Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
4. Table flight
Dates
Time
Timestamps
Extract functions
Timezone conversion
Current date and time
Review

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.