You must use Oracle for this part. Please show the complete question, query used, and print the query results. Use the TAL Distributors database only.

TAL Distributor:

DROP TABLE REP; CREATE TABLE REP( REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15) NOT NULL, FIRST_NAME CHAR(15) NOT NULL, STREET CHAR(15), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE CHAR(5), COMMISSION DECIMAL(7,2), RATE DECIMAL(3,2));

INSERT INTO REP values(15,'Campos','Rafael','724 Vinca Dr.','Grove','CA',90092,23457.50,0.06);

INSERT INTO REP values(30,'Gradey','Megan','632 Liacris St.','Fullton','CA',90085,41317.00,0.08);

INSERT INTO REP values(45,'Tian','Hui','1785 Tyler Ave.','Northfield', 'CA', 90098, 27789.25,0.06);

INSERT INTO REP values(60,'Sefton','Jauot','267 Oakley St.','Congaree','CA',90097,0.00,0.06);

DROP TABLE CUSTOMER; CREATE TABLE CUSTOMER( CUSTOMER_NUM CHAR(3) PRIMARY KEY, CUSTOMER_NAME CHAR(35) NOT NULL, STREET CHAR(20), CITY CHAR(15), STATE CHAR(2), POSTAL_CODE CHAR(5), BALANCE DECIMAL(8,2), CREDIT_LIMIT DECIMAL(8,2), REP_NUM CHAR(2));

INSERT INTO CUSTOMER values (126,'Toys Galore','28 Laketon St.','Fullton','CA',90085,1210.25,7500.00,15); INSERT INTO CUSTOMER values(260,'Brookings Direct','452 Columbus Dr.','Grove','CA',90092,575.00,10000.00,30);

INSERT INTO CUSTOMER values(334,'The Everything Shop','342 Magee St.','Congaree','CA',90097,2345.75,7500.00,45);

INSERT INTO CUSTOMER values(386,'Johnson"s Department Store','124 Main St.','Northfield','CA',90098,879.25,7500.00,30);

INSERT INTO CUSTOMER values(440,'Grove Historical Museum Store','3456 Central Ave.','Fullton','CA',90085,345.00,5000.00,45); INSERT INTO CUSTOMER values(502,'Cards and More','167 Hale St.','Mesa','CA',90104,5025.75,5000.00,15);

INSERT INTO CUSTOMER values(586,'Almondton General Store','3345 Devon Ave.','Almondton','CA',90125,3456.75,15000.00,45);

INSERT INTO CUSTOMER values(665,'Cricket Gift Shop','372 Oxford St.','Grove','CA',90092,678.90,7500.00,30);

INSERT INTO CUSTOMER values(713,'Cress Store','12 Rising Sun Ave.','Congaree','CA',90097,4234.60,10000.00,15);

INSERT INTO CUSTOMER values(796,'Unique Gifts','786 Passmore St.','Northfield','CA',90098,124.75,7500.00,45);

INSERT INTO CUSTOMER values(824,'Kline"s','945 Gilham St,','Mesa','CA',90104,2475.99,15000.00,30);

INSERT INTO CUSTOMER values(893,'All Season Gifts','382 Wildwood Ave.','Fullton','CA',90085,935.75,7500.00,15);

DROP TABLE ORDERS; CREATE TABLE ORDERS( ORDER_NUM CHAR(5) PRIMARY KEY, ORDER_DATE DATE, CUSTOMER_NUM CHAR(3));

INSERT INTO ORDERS values(51608,'2015-10-12',126);

INSERT INTO ORDERS values(51610,'2015-10-12',334);

INSERT INTO ORDERS values(51613,'2015-10-13',386);

INSERT INTO ORDERS values(51614,'2015-10-13',260);

INSERT INTO ORDERS values(51617,'2015-10-15',586);

INSERT INTO ORDERS values(51619,'2015-10-15',126);

INSERT INTO ORDERS values(51623,'2015-10-15',586);

INSERT INTO ORDERS values(51625,'2015-10-16',796);

DROP TABLE ITEM; CREATE TABLE ITEM( ITEM_NUM CHAR(4) PRIMARY KEY, DESCRIPTION CHAR(30), ON_HAND DECIMAL(4,0), CATEGORY CHAR(3), STOREHOUSE CHAR(1), PRICE DECIMAL(6,2)); INSERT INTO ITEM values ('AH74','Patience',9.00,'GME','3',22.99); INSERT INTO ITEM values ('BR23','Skittles',21.00,'GME','2',29.99); INSERT INTO ITEM values ('CD33','Wood Block Set (48 piece)',36.00,'TOY','1',89.49); INSERT INTO ITEM values ('DL51','Classic Railway Set',12.00,'TOY','1',107.95); INSERT INTO ITEM values ('DR67','Giant Star Brain Teaser',24.00,'PZL','2',31.95); INSERT INTO ITEM values ('DW23','Mancala',40.00,'GME','3',50.00); INSERT INTO ITEM values ('FD11','Rocking Horse',8.00,'TOY','3',124.95); INSERT INTO ITEM values ('FH24','Puzzle Gift Set',65.00,'PZL','1',38.95); INSERT INTO ITEM values ('KA12','Cribbage Set',56.00,'GME','3',75.00); INSERT INTO ITEM values ('KD34','Pentominous Brain Teaser',60.00,'PZL','2',14.95); INSERT INTO ITEM values ('KL78','Pick Up Sticks',110.00,'GME','1',10.95); INSERT INTO ITEM values ('MT03','Zauberkasten Brain Teaser',45.00,'PZL','1',45.79); INSERT INTO ITEM values ('NL89','Wood Block Set (62 piece)',32.00,'TOY','3',119.75); INSERT INTO ITEM values ('TR40','Tic Tac Toe',75.00,'GME','2',13.99); INSERT INTO ITEM values ('TW35','Fire Engine',30.00,'TOY','2',118.95);

DROP TABLE ORDER_LINE; CREATE TABLE ORDER_LINE( ORDER_NUM CHAR(5), ITEM_NUM CHAR(4), NUM_ORDERED DECIMAL(3,0), QUOTED_PRICE DECIMAL(6,2), PRIMARY KEY (ORDER_NUM, ITEM_NUM));

INSERT INTO ORDER_LINE values(51608,'CD33',5.00,86.99); INSERT INTO ORDER_LINE values(51610,'KL78',25.00,10.95); INSERT INTO ORDER_LINE values(51610,'TR40',10.00,13.99); INSERT INTO ORDER_LINE values(51613,'DL51',5.00,104.95); INSERT INTO ORDER_LINE values(51614,'FD11',1.00,124.95); INSERT INTO ORDER_LINE values(51617,'NL89',4.00,115.99); INSERT INTO ORDER_LINE values(51617,'TW35',3.00,116.95); INSERT INTO ORDER_LINE values(51619,'FD11',2.00,121.95); INSERT INTO ORDER_LINE values(51623,'DR67',5.00,29.95); INSERT INTO ORDER_LINE values(51623,'FH24',12.00,36.95); INSERT INTO ORDER_LINE values(51623,'KD34',10.00,13.10); INSERT INTO ORDER_LINE values(51625,'MT03',8.00,45.79);

DROP TABLE SALESREP; CREATE TABLE SALES_REP( REP_NUM char(2), LAST_NAME varchar(15), FIRST_NAME char(15), STREET char(15), CITY char(15), STATE char(2), POSTAL_CODE char(5), COMMISSION decimal(11,2), RATE decimal(11,2), PRIMARY KEY (REP_NUM) );

Review Questions 1. How do you join tables in SQL? 2. When must you qualify names in SQL commands? How do you qualify a column name? 3. List two operators that you can use with subqueries as an alternate way of performing joins. 4. What is a nested subquery? In which order does SQL evaluate nested subqueries? 5. What is an alias? How do you specify an alias in SQL? How do you use an alias? 6. How do you join a table to itself in SQL? 7. How do you take the union of two tables in SQL? How do you take the intersection of two tables in SQL? How do you take the difference of two tables in SQL? Are there any restrictions on the tables when performing any of these operations? 8. What does it mean for two tables to be union compatible? 9. How do you use the ALL operator with a subquery? 10. How do you use the ANY operator with a subquery? 11. Which rows are included in an inner join? What clause can you use to perform an inner join in SQL? 12. Which rows are included in a left outer join? What clause can you use to perform a left outer join in SQL? 13. Which rows are included in a right outer join? What clause can you use to perform a right outer join in SQL? 14. What is the formal name for the product of two tables? How do you form a product in SQL? 15. Use the Internet to find definitions for the terms equi-join, natural join, and cross join. Write a short report that identifies how these terms relate to the terms join, inner join, and Cartesian product. Be sure to reference your online sources properly. 16. Use the Internet to find information on cost-based query optimizers. Write a short report that explains how cost-based query optimization works, and what type(s) of queries benefit the most from cost-based query optimization. Be sure to reference your online sources properly