EssayproSolutions

(Solved) : Microsoft Sql Server Query Functions Write Select Statement Returns Columns Orders Table O Q37234229 . . .

MICROSOFT SQL SERVER, QUERY, FUNCTIONS

Write a SELECT statement that returns these columns from theOrders table:
—           The OrderIDand CardNumber columns,
—           The length ofthe CardNumber column,
—           The last fourdigits of the CardNumber column,
—           When you getthat working right, add the column that follows to the resultset.
—              This is more difficult because the columnrequires the use of functions within functions.
—           A column thatdisplays the last four digits of the CardNumber column in thisformat: XXXX-XXXX-XXXX-1234.
—              In other words, use Xs for the first 12 digitsof the card number
—              and actual numbers for the last four digits ofthe number.
—       Sort OrderID in descendingorder.
—       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…