Kursusindhold
SQL Basics
SQL Basics
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!
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!
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder