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).
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
single
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 2.63Awesome!
Completion rate improved to 2.63MINimal 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).
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
single
Awesome!
Completion rate improved to 2.63MINimal and MAXimal values
Scorri per mostrare il menu
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).
Soluzione
Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguentiGrazie per i tuoi commenti!
