Question: 5. Write a SQL statement that selects these columns from the Orders table: order_id The order_id column order_date The order_date column ship_amount The ship_amount column

5. Write a SQL statement that selects these columns from the Orders table: order_id The order_id column order_date The order_date column ship_amount The ship_amount column ship_date The ship date column Round the ship amount to 1 decimal place. Only return data where ship_date doesn't contain null. Limit results to 5 rows. 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
