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

Course Content

SQL Basics

SQL Basics

1. Selecting
2. Filtering
3. Aggregating
4. Sorting
5. Grouping
6. Practicing

bookChallenge: Average price for each model and year

Task
test

Swipe to show code editor

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.

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
toggle bottom row

bookChallenge: Average price for each model and year

Task
test

Swipe to show code editor

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.

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
toggle bottom row

bookChallenge: Average price for each model and year

Task
test

Swipe to show code editor

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.

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!

Task
test

Swipe to show code editor

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.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 6. Chapter 6
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt