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

Instruction

Good. Let's introduce the tables we're going to work with. A European airline called PerfectAir revealed 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 its:

  • code used for identification,
  • the international code of the departure airport (from_airport),
  • the international code of the arrival airport (to_airport),
  • a distance of the route (distance) expressed in kilometers,
  • departure which stores the time of planned departure,
  • and arrival holding the information about planned time of arrival.
Keep in mind that both of these values are shown in Central European Time.

Console

Code editor

Result

TableConsole