Mean 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

Завдання

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

Завдання

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

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 3. Розділ 3

Mean 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

Завдання

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

Завдання

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

Все було зрозуміло?

Секція 3. Розділ 3

Mean 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

Завдання

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

Завдання

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

Все було зрозуміло?

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

Завдання

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

Секція 3. Розділ 3