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


Good job. Two more questions to go!


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