# 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 Answer.

#### Correct SQL: