MIN Finds the Smallest Value

`MIN` returns the smallest value in a column.

SELECT MIN(amount) AS smallest_sale
FROM sales

This is useful when you want to know the lowest price, earliest date, or smallest score in a dataset.