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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
single
Awesome!
Completion rate improved to 2.63Mean values
Pyyhkäise näyttääksesi valikon
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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
