Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Mean values | Aggregating
SQL Basics

bookMean 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.


              
123

            
SELECT AVG(mileage)
FROM audi_cars
WHERE year = 2020
copy
Oppgave

Swipe to start coding

Using table audi_cars calculate the average price of the A4 model manufactured in 2018.

Løsning

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 3
single

single

Spør AI

expand

Spør AI

ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

close

Awesome!

Completion rate improved to 2.63

bookMean values

Sveip for å vise menyen

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.


              
123

            
SELECT AVG(mileage)
FROM audi_cars
WHERE year = 2020
copy
Oppgave

Swipe to start coding

Using table audi_cars calculate the average price of the A4 model manufactured in 2018.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 3
single

single

some-alt