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