Introduction
Quiz
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 car_size columns.
Show the following columns in the query result: year, country, car_size, y, c, cs showing if the columns year, country, car_size, respectively, is included in the grouping, and min_fuel_consumption.
To calculate fuel consumption per 100 km, divide fuel_consumed by distance, and multiply the result by 100.
Stuck? Here's a hint!
To calculate min_fuel_consumption, use the following:
MIN((fuel_consumed/distance)*100) AS min_fuel_consumption
