CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 61

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.
item_id: 11
title: Ode To My ERD
artist: 15
unit_price: 7.95
Show your UPDATE statement along with the results of the following
SELECT query to verify that the insert worked correctly.