CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 60

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;
15. Using the SUBSTRING and CONCAT functions, write a query
to display each customer name as a single field in the format
―Jones, Tom‖ with a heading of Customer along with the
customer_phone field in a nicely formatted calculated column
named Phone. For example, a record containing the
customer_phone value 6145535443 would be output with
parentheses, spaces, and hyphens, like this: [phone]. Sort by
last name.
This is the end of Lab 4.
===========================================
CIS 336 iLab 5 Joining Tables