As you may 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 prices in the products table and returns the price with 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.
Use a MAX aggregation to return the age of our oldest CashPal user who is also an admin. Alias the returned age column to just be named "age".
| id | name | age | country_code | username | password | is_admin |