Challenge: Relation between engine size and fuel consumption
Tâche
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
.
Solution
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.
Tout était clair ?
Merci pour vos commentaires !
Section 6. Chapitre 4