MySQL

MIN() and MAX()

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

Write each of the following tasks as a SQL statement in a new line (remember that you can source the file to compare the output reference):

1 - Select the minimum product stock and maximum product stock of the e_store.products table that would output this:

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