Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Dates
10. Dates – additional practice
Time
Timestamps
Extract functions
Timezone conversion
Current date and time
Review

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.