Introduction
Dates
10. Dates – additional practice
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.

Console

Code editor

Result

TableConsole