We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

This lesson's interactive features are locked, please to keep using them

MIN

The MIN function works the same as the MAX function but finds the lowest value instead of the highest value.

SELECT product_name, MIN(price)
FROM products;

This query returns the product_name and the price fields of the record with the lowest price.

Assignment

Users Table

| id | name | age | country_code | username | password | is_admin |