Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Apprendre MINimal and MAXimal values | Aggregating
SQL Basics

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


              
123

            
SELECT MIN(price)
FROM audi_cars
WHERE transmission = 'Automatic'
copy

Please note, that unlike for DISTINCT function you need to use parentheses for MIN and MAX functions.

Tâche

Swipe to start coding

From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 1
single

single

Demandez à l'IA

expand

Demandez à l'IA

ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

close

Awesome!

Completion rate improved to 2.63

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


              
123

            
SELECT MIN(price)
FROM audi_cars
WHERE transmission = 'Automatic'
copy

Please note, that unlike for DISTINCT function you need to use parentheses for MIN and MAX functions.

Tâche

Swipe to start coding

From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 1
single

single

close

Awesome!

Completion rate improved to 2.63

bookMINimal and MAXimal values

Glissez pour afficher le 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.


              
123

            
SELECT MIN(price)
FROM audi_cars
WHERE transmission = 'Automatic'
copy

Please note, that unlike for DISTINCT function you need to use parentheses for MIN and MAX functions.

Tâche

Swipe to start coding

From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

some-alt