CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 62

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.