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

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.