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.
Løsning
Tak for dine kommentarer!
single
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat
Opsummér dette kapitel
Explain code
Explain why doesn't solve task
Fantastisk!
Completion rate forbedret til 2.63Mean values
Stryg for at vise menuen
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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederTak for dine kommentarer!
single
