CIS 336 Week 6 iLab 6 Devry University (Devry)

December 21, 2015  |  By  | 


Category: Education

FOR MORE CLASSES VISIT www.cis336papers.com Week 6. L A B S T E P S STEP 1: Back to top Using the BOOK_CUSTOMER table and the NVL function, create a query that will return a list containing the customer number, first name, last name, and the characters ‘NOT REFERRED’ if the customer was not referred by another customer. Give the derived column an alias of REFERRED BY. Do not list any customers that were referred by another customer. STEP 2: Back to top Using the BOOKS table and the SUBSTR function, create a query that will return a list of book ISBN codes and

More from veeru12

Page 1 / 4