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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started