Question: A sql-6-2.sql file has been opened for you. Write each of the following tasks as a SQL statement in a new line (remember that you

A sql-6-2.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):

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) 

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

 

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!