Challenge: Relation between engine size and fuel consumption
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 mulighederTak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Challenge: Relation between engine size and fuel consumption
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 mulighederTak for dine kommentarer!
single
Awesome!
Completion rate improved to 2.63Challenge: Relation between engine size and fuel consumption
Stryg for at vise menuen
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 mulighederTak for dine kommentarer!
