Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Mean values | Aggregating
SQL Basics

bookMean values

The next function we will talk about - is mean. Mean (average) is probably one of the most simple and usable statistics in real life.

For example, for our audi_cars table, we can calculate the average mileage for cars manufactured in 2020. To calculate the average use AVG function followed by column name.


              
123

            
SELECT AVG(mileage)
FROM audi_cars
WHERE year = 2020
copy
Task

Swipe to start coding

Using table audi_cars calculate the average price of the A4 model manufactured in 2018.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 3
single

single

Ask AI

expand

Ask AI

ChatGPT

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

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

close

bookMean values

Swipe to show menu

The next function we will talk about - is mean. Mean (average) is probably one of the most simple and usable statistics in real life.

For example, for our audi_cars table, we can calculate the average mileage for cars manufactured in 2020. To calculate the average use AVG function followed by column name.


              
123

            
SELECT AVG(mileage)
FROM audi_cars
WHERE year = 2020
copy
Task

Swipe to start coding

Using table audi_cars calculate the average price of the A4 model manufactured in 2018.

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Β 3. ChapterΒ 3
single

single

some-alt