This lesson's interactive features are locked, please to keep using them

MAX

As you might expect, the MAX function retrieves the largest value from a set of values. For example:

SELECT MAX(price)
FROM products;

This query looks through all the rows in the products table and returns the largest price value. Remember, it only returns the price, not the rest of the record! You always need to specify each field you want a query to return.

Assignment

Use a MAX aggregation to return the age of our oldest CashPal user who is also an admin.
Alias the returned column so that it's just named age.

Users Table

| id | name | age | country_code | username | password | is_admin |