Sql Server Database Write Select Statement Returns Columns Orders Table Orderid Orderdate Q37234152

SQL SERVER DATABASE

Write a SELECT statement that returns these columns from theOrders table:
—           The OrderIDand OrderDate columns
—           A column thatreturns the four-digit year that’s stored in the OrderDatecolumn
—           A column thatreturns only the day of the month that’s stored in the OrderDatecolumn.
—           A column thatreturns the result from adding thirty days to the OrderDate column(use the alias DueDate).
—       Sort OrderDate in descendingorder.
—       Make sure you name yourcolumns.
—       2 points
—       I got 41 rows.
—       QUESTION:   What isDueDate in record 5?
—       ANSWER:     

Answer