Use the aggregate function MAX() to find the maximum of a set of values.
Listing 6.2 and Figure 6.2 show some queries that involve MAX(). The first query returns the author’s last name that is last alphabetically. The second query returns the prices of the cheapest and most expensive books, and the price range. The third query returns the highest revenue (= price × sales) among the history books.
SELECT MAX(au_lname) AS "Max last name" FROM authors; SELECT MIN(price) AS "Min price", MAX(price) AS "Max ...