Introduction
Summary
18. Exercise 2

Instruction

Great! One more question.

Exercise

Find the maximum total price in all grouping combinations based on the Country and Customer columns. Group all rows by the Customization column. Instead of NULLs in the Country and Customer columns, show a double dash (--) in the Country and Customer columns.

Show the following columns in the query result: Country, Customer, Customization, and MaxTotalPrice.