MIN and MAX find the smallest and largest

MIN hands back the lowest value in a column and MAX the highest — the cheapest price, the latest date. Each gives back that one value on its own. It does not tell you which row the value came from; finding that row takes a different query.

SELECT MIN(price) AS cheapest
FROM books;