CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 66

9. Write a query which displays the order id, customer id and order
date for all orders that have NOT been shipped, sorted by order date
with the most recent order at the top.
10. 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.
11. Write a query to display the customer last name, phone number,
and fax number but only display those customers that have a fax
number.
12. Create a statement to insert a new record into the items table with
the following values:
item_id: 11
title: Ode To My ERD
Artist_id: 15
unit_price: 12.95
Show your INSERT statement along with the results of the following
SELECT query to verify that the insert worked correctly.
select * from items where item_id> 10;
13. Create a statement to update the record inserted in the previous
step to change the unit price of this item to 7.95.