Challenge: Relation between engine size and fuel consumption
Compito
Swipe to start coding
From the audi_cars
table calculate the average fuel consumption (mpg
column) for each engine size (enginesize
). Order results in descending order by the average value of mpg
. Expected output: enginesize | average mpg
.
Soluzione
The result may seem strange, but don't forget that the
mpg
column refers to miles per gallon. The greater this value, the less fuel car consumes.
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 6. Capitolo 4