MINimal and MAXimal values
Now it's time to talk about aggregate functions - functions that calculate some summary stats. Let's start with extremal summary stats - minimum and maximum values.
To find the minimum (or maximum) value in the column use MIN (or MAX) functions followed by column name. For example, we can find out the cheapest car with Automatic transmission.
123SELECT MIN(price) FROM audi_cars WHERE transmission = 'Automatic'
Please note, that unlike for
DISTINCTfunction you need to use parentheses forMINandMAXfunctions.
Swipe to start coding
From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Awesome!
Completion rate improved to 2.63MINimal and MAXimal values
Sveip for å vise menyen
Now it's time to talk about aggregate functions - functions that calculate some summary stats. Let's start with extremal summary stats - minimum and maximum values.
To find the minimum (or maximum) value in the column use MIN (or MAX) functions followed by column name. For example, we can find out the cheapest car with Automatic transmission.
123SELECT MIN(price) FROM audi_cars WHERE transmission = 'Automatic'
Please note, that unlike for
DISTINCTfunction you need to use parentheses forMINandMAXfunctions.
Swipe to start coding
From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
single
