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: (614) 555-5443. Sort by last name. This is the end of Lab 4.