CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 62

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

FOR MORE CLASSES VISIT
www.cis336study.com

CIS336: Lab5: Joining Tables
LAB OVERVIEW
Scenario and Summary