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

Common Functions in PostgreSQL

Final Quiz
12. Exercise 10

Instruction

Awesome! This is the last one!

Exercise

Let's see what aircraft were used while the Boeing 777-300 (ID of 8) was flying. You may remember that query from the exercise from the Date and Time functions part. Back then, we weren't able to show aircraft that were still flying, because of NULLs in the withdrawn_timestamp column. This time we want to see them too.

Stuck? Here's a hint!

You'll have to update the WHERE condition using the COALESCE() function: replace NULLs in the other.withdrawn_timestamp column with current timestamp.