Kursusindhold
SQL Basics
SQL Basics
6. Practicing
Challenge: Unique combinationsChallenge: Average Q-series cars priceChallenge: The cheapest new A-series carsChallenge: Relation between engine size and fuel consumptionChallenge: Mileage and manufacture year - is there relation?Challenge: Average price for each model and yearChallenge: The most expensive transmission + engine size combinations
Challenge: Average price for each model and year
Opgave
Swipe to start coding
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Løsning
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 6
Challenge: Average price for each model and year
Opgave
Swipe to start coding
From the audi_cars table calculate the average price for each combination of model and year. Round average price to 0 decimals (so make it integer). Sort values by year.
Løsning
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 6
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder