Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
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.