Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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