Question: 4 . Write a SELECT statement that returns these columns from the Orders table:The order _ id columnThe order _ date columnA column named approx
Write a SELECT statement that returns these columns from the Orders table:The orderid columnThe orderdate columnA column named approxshipdate thats calculated by adding days to the orderdate columnThe shipdate column if it doesnt contain a null valueA column named daystoship that shows the number of days between the order date and the ship dateWhen you have this working, add a WHERE clause that retrieves just the orders for March
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
