Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Challenge: Average price for each model and year | Practicing
SQL Basics

bookChallenge: 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

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 6. Kapitel 6
single

single

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Opsummér dette kapitel

Explain code

Explain why doesn't solve task

close

Awesome!

Completion rate improved to 2.63

bookChallenge: Average price for each model and year

Stryg for at vise menuen

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

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 6. Kapitel 6
single

single

some-alt