Question: 6. Write a SELECT statement that returns these columns from the Orders table: The order_id column The order_date column A column named approx_ship_date thats calculated
6. Write a SELECT statement that returns these columns from the Orders table: The order_id column The order_date column A column named approx_ship_date thats calculated by adding 2 days to the order_date column The ship_date column A column named days_to_ship that shows the number of days between the order date and the ship date When you have this working, add a WHERE clause that retrieves just the orders for March 2012.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
