Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
4. Question 2
The End


Nice job! Let's move on.


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