Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
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.