Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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.