Introduction
Quiz
6. Question 4
The End

Instruction

Good job. Two more questions to go!

Exercise

Find the minimum fuel consumption per 100 km for all grouping combinations involving the Year, Country, and CarSize columns.

Show the following columns in the query result: GroupingId, Year, Country, CarSize, and MinFuelConsumption.

To calculate fuel consumption per 100 km, divide FuelConsumed by Distance, and multiply the result by 100.

Stuck? Here's a hint!

To calculate MinFuelConsumption, use the following:

MIN((FuelConsumed/Distance)*100) AS MinFuelConsumption