CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 47

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.
select * from items where item_id> 10;
14. Create a statement to delete the entire record that was inserted and then updated in the
previous steps.
Show your DELETE statement along with the results of the following SELECT query to
verify that the insert worked correctly.
select * from items where item_id> 10;