Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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.