Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

GROUP BY Extensions in MS SQL Server

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