Challenge: Relation between engine size and fuel consumption
Opgave
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.
Løsning
The result may seem strange, but don't forget that the
mpgcolumn refers to miles per gallon. The greater this value, the less fuel car consumes.
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 6. Kapitel 4
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder