Unit 2 Lab Activity - SQL Questions 5 through 7 - Need help on these SQL statements, please note that I am using the cloud database version of apex.oracle. All other tables have no data in them. I have also included the database from apex.oracle. (unable to make further edits as of this posting) SQL Questions 5 through 7 - Unit 2 Lab Activity - Need help on these SQL statements, please note that I am using the cloud database version of apex.oracle.

Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle APEX, type in your statement, and execute it. Code and execute each exercise separately. Save both your statement and the results to a Word document. After all queries have been completed, submit the Word document to the appropriate location. Before these labs can be completed, the JustLee Books database must be created. Download the script file from the SQL Files folder: LUO2 File If you have not done so already, run this script file. Refer to the directions in Running SQL and Viewing Results on how to load and execute script files. 5. Create a list containing the publisher's name, the person usually contacted, and the publisher's telephone number. Rename the contact column Contact Person in the display results. 6. Determine which categories are represented in the current book inventory. List each category only once. 7. List the customer numbers who have placed an order with JustLee Books. List each customer number only once. AUTHOR Table Data Indexes Model Constraints Grants Statistics UI Defaults Triggers Dependencies SQL REST Sample Queries Query Count Rows Insert Row Load Data EDIT AUTHORID LNAME FNAME S100 SMITH SAM J100 JONES JANICE A100 AUSTIN JAMES M100 MARTINEZ SHEILA K100 KZOCHSKY TAMARA P100 PORTER LISA A105 ADAMS JUAN B100 BAKER JACK P105 PETERSON TINA W100 WHITE WILLIAM W105 WHITE LISA R100 ROBINSON ROBERT F100 FIELDS OSCAR W110 WILKINSON ANTHONY CUSTOMERS + Table Data Indexes Model Constraints Grants Statistics UI Defaults Triggers Dependencies SQL REST Sample Queries Query Count Rows Insert Row Load Data EDIT CUSTOMER# LASTNAME FIRSTNAME ADDRESS CITY STATE ZIP REFERRED REGION 1001 MORALES BONITA P.O. BOX 651 EASTPOINT FL 32328 SE 1002 THOMPSON RYAN P.O. BOX 9835 SANTA MONICA CA 90404 W 1003 SMITH LEILA P.O. BOX 66 TALLAHASSEE FL 32306 - SE 1004 PIERSON THOMAS 69821 SOUTH AVENUE BOISE ID 83707 NW 1005 GIRARD CINDY P.O. BOX 851 SEATTLE WA 98115 - NW 1006 CRUZ MESHIA 82 DIRT ROAD ALBANY NY 12211 NE 1007 GIANA TAMMY 9153 MAIN STREET AUSTIN TX 78710 1003 SW 1008 JONES KENNETH P.O. BOX 137 CHEYENNE WY 82003 N 1009 PEREZ JORGE P.O. BOX 8564 BURBANK CA 91510 1003 W 1010 LUCAS JAKE 114 EAST SAVANNAH ATLANTA GA 30314 SE 1011 MCGOVERN REESE P.O. BOX 18 CHICAGO IL 60606 - N 1012 MCKENZIE WILLIAM P.O. BOX 971 BOSTON MA 02110 NE 1013 NGUYEN NICHOLAS 557 WHITE EAGLE AVE. CLERMONT FL 34711 1006 SE 1014 LEE JASMINE P.O. BOX 2947 CODY WY 82414 N 1015 SCHELL STEVE P.O. BOX 677 MIAMI FL 33111 SE Download rowlol 1 15 of an Movt CUSTOMERS + v Table Data Indexes Model Constraints Grants Statistics UI Defaults Triggers Dependencies SQL REST Sample Queries Query Count Rows Insert Row Load Data EDIT CUSTOMER# LASTNAME FIRSTNAME ADDRESS CITY STATE ZIP REFERRED REGION 1016 DAUM MICHELL 9851231 LONG ROAD BURBANK CA 91508 1010 W 1017 NELSON BECCA P.O. BOX 563 KALMAZOO MI 49006 N. 1018 MONTIASA GREG 1008 GRAND AVENUE MACON GA 31206 SE 1019 SMITH JENNIFER P.O. BOX 1151 MORRISTOWN NJ 07962 1003 NE 1020 FALAH KENNETH P.O. BOX 335 TRENTON NJ 08607 NE Download