CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 67

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
FOR MORE CLASSES VISIT