MySQL

SQL MIN()

A sql-6-1.sql file has been opened for you.

Write each of the following tasks as a SQL statement in a new line:

Select the product with the least stock from the e_store.products table. The output should look like this:

+------------+ | MIN(stock) | +------------+ | 1 | +------------+ 1 row in set (0.03 sec) 

Select the product with the least stock from the e_store.products table aliasing the column name as: min_stock. The output should look like this:

+-----------+ | min_stock | +-----------+ | 1 | +-----------+ 1 row in set (0.01 sec) 

Select the product with the least stock from the e_store.products table where the id is greater than 3. Alias the column name as: min_stock. The output should look like this:

+-----------+ | min_stock | +-----------+ | 4 | +-----------+ 1 row in set (0.02 sec)