SELECT MAX (company) FROM Sales WHERE net_amount > 100; The MAX function is sometimes used on columns containing an auto-incremented key field to determine what the next entry’s key ID will be.