The marketing department has requested a new report of


The Marketing Department has requested a new report of shipped orders for which the order was placed on either a Saturday or a Sunday. Write a query which displays the order id, order date, shipped date, along with a calculated column labeled "Order_Day" showing the day of the week the order was placed (use the DAYNAME function). Only display orders that have shipped and were placed on a Saturday or Sunday. Sort by order date with most recent orders at the top.

Solution Preview :

Prepared by a verified Expert
Business Management: The marketing department has requested a new report of
Reference No:- TGS02179459

Now Priced at $10 (50% Discount)

Recommended (97%)

Rated (4.9/5)