Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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