Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Dealing with dates
10. Dates – exercise
Working with time
Date and time data types in PostgreSQL
Extracting dates and times
Timezone conversion
Format date and time
Current date and time data


Okay, let's try a more complicated exercise.


For every aircraft produced in 2010, show its ID, production date, and the route codes for all the distinct routes it flies.

Stuck? Here's a hint!

For distinctive codes, use DISTINCT.

To show the codes, you will need to JOIN two tables.