CIS 336 iLab 4 Introduction to Select, Insert, Update, and Delete Sta CIS 336 iLab 4 Introduction to Select, Insert, Upd | Page 3

7. Write a query that displays the order id and order date for any orders placed during the
month of May, 2014. Do this using the BETWEEN clause. Format the date field as mm/dd/yy
and use a heading of “Ordered”.
8. Write a query which displays the order id, customer id, and the number of days between the
order date and the ship date (use the DATEDIFF function). Name this column “Days” and sort by
highest to lowest number of days. Only display orders where this result is 15 days or more.
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 uni