This site runs best with JavaScript enabled.Lesson 20: Finding the minimum and maximum values using MIN and MAX functions.

Lesson 20: Finding the minimum and maximum values using MIN and MAX functions.


Highest.

If we want to find out what the highest value within a specified column is, we use the MAX function. This gives us the MAXIMUM value. Like this,

SELECT MAX(IntlCaps)
FROM Footballers;

Lowest.

If we want to find out what the lowest value within a specified column is, we use the MIN function. This gives us the MINIMUM value. For example,

SELECT MIN(IntlCaps)
FROM Footballers;

Quiz Time.

The Question.

We can use our new found MIN and MAX superpowers to get the answer to both of these questions in one query: 1) what was the lowest budget of the four Avengers movies AND 2) what was the highest budget of the four Avengers movies?

The Data.

The Editor.



The Answer.

Correct SQL:

Correct Output:

Share lesson