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.
123SELECT AVG(mileage) FROM audi_cars WHERE year = 2020
Swipe to start coding
Using table audi_cars
calculate the average price of the A4 model manufactured in 2018.
Рішення
Дякуємо за ваш відгук!
single
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
Сумаризуйте цей розділ
Пояснити код у file
Пояснити, чому file не вирішує завдання
Awesome!
Completion rate improved to 2.63
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.
123SELECT AVG(mileage) FROM audi_cars WHERE year = 2020
Swipe to start coding
Using table audi_cars
calculate the average price of the A4 model manufactured in 2018.
Рішення
Дякуємо за ваш відгук!
Awesome!
Completion rate improved to 2.63single