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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63Mean 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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
Awesome!
Completion rate improved to 2.63Mean values
Deslize para mostrar o 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.
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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
