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!
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