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
2. Table route
Dates
Time
Timestamps
Extract functions
Timezone conversion
Current date and time
Review

Instruction

Good. Let's introduce the tables we're going to work with. A European airline called PerfectAir provided some of its data to us. Let's see what we have received from them.

Exercise

Select all the information for the table route.

The table route keeps track of the destinations offered by PerfectAir. Each route has:

  • an ID code used for identification.
  • the international code of the departure airport (from_airport).
  • the international code of the arrival airport (to_airport).
  • total distance of the route (distance) expressed in kilometers.
  • departure which stores the scheduled time of departure.
  • arrival containing information about planned time of arrival.

Keep in mind that both of the time values are shown in Central European Time.