Introduction
Dates
Time
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

## Instruction

Okay, let's try a more complicated example for additional practice.

## Exercise

For each aircraft produced in 2010, show its id, production date and the distinctive codes of routes they operate on (rename the column to route_code).

### Stuck? Here's a hint!

For distinctive codes, use DISTINCT. In order to show the codes, you will need to JOIN two tables.

Code editor

TableConsole