MySQL

Multiple functions

A sql-6-3.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- In a single SELECT query, from the e_store.products table: Display the product with the least stock aliasing the column name as: least_stock, the newest product aliasing the column name as: newest_product and the most expensive product aliasing the column name as: product_max_price. The output should look like this:

+-------------+---------------------+-------------------+ | least_stock | newest_product | product_max_price | +-------------+---------------------+-------------------+ | 1 | 2015-10-30 06:30:30 | 157.40 | +-------------+---------------------+-------------------+ 1 row in set (0.01 sec)