Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
Quiz
4. Question 2
The End

Instruction

Nice job! Let's move on.

Exercise

Find the maximum amount of fuel consumed for all grouping combinations involving the Country, CarSize, and TripType columns. Show the following columns in the query result: Country, CarSize, TripType, and MaxFuelConsumed. Replace all NULL values in the first three columns with a double dash --.

Stuck? Here's a hint!

To replace NULL values with --, use the COALESCE() function. Here's an example:

COALESCE(Country, '--') AS Country