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.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Awesome!
Completion rate improved to 2.63
Mean values
Desliza para mostrar el menú
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.
Solución
¡Gracias por tus comentarios!
Awesome!
Completion rate improved to 2.63single