Question: 6. Write a SQL statement without a FROM clause that uses the NOW function to create a row with these columns: today_unformatted The NOW function

6. Write a SQL statement without a FROM clause that uses the NOW function to create a row with these columns: today_unformatted The NOW function unformatted today_formatted The NOW function in this format: 'MM/DD/YYYY This displays a 2 digit number for the month, 2 digit number of the day, and a four-digit year. 7. Write a SQL SELECT statement without a FROM clause that creates a row with these columns: Item_price 10 (10 dollars) Discount_percent 25 (25 percent) Discount_amount Item_price multiplied by Discount_percent Final_price Item_price minus (Item_price multiplied by Discount_percent) To calculate the third column, add the expressions you used for the first and third Note: reuse the expression copy paste, aliasing will not work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
