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

bookChallenge: Average price for each model and year

Task

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.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 6. ChapterΒ 6
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

close

Awesome!

Completion rate improved to 2.63

bookChallenge: Average price for each model and year

Task

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.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 6. ChapterΒ 6
single

single

close

Awesome!

Completion rate improved to 2.63

bookChallenge: Average price for each model and year

Swipe to show menu

Task

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.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

some-alt