Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
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