(Solved) : Microsoft Sql Server Query Functions Write Select Statement Returns Columns Orders Table O Q37234287 . . .
MICROSOFT SQL SERVER, QUERY, FUNCTIONS
Write a SELECT statement that returns these columns from theOrders table:
— The OrderIDcolumn,
— The OrderDatecolumn,
— A column namedApproxShipDate that’s calculated by adding 2 days to the OrderDatecolumn,
— The ShipDatecolumn,
— A column namedDaysToShip that shows the number of days between the order date andthe ship date
— When you havethis working, add a WHERE clause that retrieves just the orders forApril 2016.
— Sort OrderDate in ascendingorder.
— Make sure you name yourcolumns.
Expert Answer
Answer to MICROSOFT SQL SERVER, QUERY, FUNCTIONS Write a SELECT statement that returns these columns from the Orders table: — The…
OR