Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
3. Table aircraft
Dates
Time
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

## Instruction

Perfect, you know the table route. Let's check another one.

## Exercise

Select all the information for the table aircraft.

PerfectAir has its own fleet and each aircraft is listed in the table. An aircraft has an id and model. The table also stores columns:

• produced – when the production of the aircraft was officially finished and the aircraft was ready to be sold,
• launched – when the aircraft took its first flight for PerfectAir.

These two dates may differ significantly when, e.g., PerfectAir bought a used aircraft. You may have noticed that launched is a more accurate column (it shows the time, too). This is because PerfectAir wants to mark the exact point in time when the aircraft took off the ground for the first time.

The last column is withdrawn – an exact point in time where the aircraft landed for the last time before it retired.