This is the end of Lab 4. =================================================== CIS 336 iLab 5 Joining Tables
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:( 614) 555-5443. Sort by last name.
This is the end of Lab 4. =================================================== CIS 336 iLab 5 Joining Tables