MySQL

5. 1. Challenge

SQL MAX()

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

1 - 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):

Select the newest product from the e_store.productstable. Alias the column name as: newest_product. The output should look like this:

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

2 - Select the oldest product from the e_store.products table. Alias the column name as: oldest_product. The output should look like this;

+---------------------+ | oldest_product | +---------------------+ | 2015-10-09 00:49:30 | +---------------------+ 1 row in set (0.01 sec)