8.) Paste a screen shot of your results from question 7 9.) How would you show all the authors with a last name of "WHITE"? Make sure to just output the AuthorlD and LNAME. 10.)Paste a screen shot of your results from question 9 CREATE TAELE Cus tomers (Customer# NUMBER (4), LastName VAR CHAR 2 (10) NOT NULL FirstName VARCHAR2 (10) NOT NULL, Addre VARCHAR2 (20), City VARCHAR 2 (12). State VARCHAR2 (2), 2ip VARCHAR2 (5) Refer red NUMBER (4), Region CHAR (2) CONSTRAINT customers-cus tomert_pk CONSTRAINI cus tome_region ck PRIMARY KEY(cus tomer# }, CHECK (region IN ('N"NW", 'NE', 3',SE" INSERT INTO CUSTOERS VALUE 3 (1001, "MORALESBONITA P. EOX 651EASTPOINT EL32328NULL, E' INSERT INTO CUSTOERS VALUE 3 (1002, 'THOMPSON', 'RYAN', 'P-0. BOX 9835", 'SANTA MONICA 'A90404*, NULL, '; INSERT INTO CUSTOERS VALUE (1003 SMITH', 'LE ILAP.O BOX ETALLAHASSEE EL3230NULL, E' INSERT INTO CUSTOERS VALUE (1004IER3ONTHOMAS*, 9821 8OUTH AVENUE BOISE', 'ID , .837 07 . , NULL, "Ni"); INSERT INTO CUSTOERS VALUE (1005 GIRARD*, CINDY.O. BOX B51SEATTLE INSERT INTO CUSTOERS VALUE (100CRU2 MESHIA, 82 DIRT ROAD,ALBANYNY" 12211, NULL, 'NE INSERT INTO CUSTOERS VALUE (1007GIANa*, 'TAMMY',9153 MAIN STREET'AUSTIN TX78710 , 1003 ) INSERT INTO CUSTOERS VALUE 3 (1008, JONE 3 . , 'EENNETH', 'P-O. BOX 137', CHEYENNE', "NY' , . 8 2008" , NULL, 'N ') ; INSERT INTO CUSTOERS VALUE (1009EREZ, JORGE P.O BOX B564BURBANK', CA91510 ,1003. "*) INSERT INTO CUSTOERS VALUE (1010LUCASJARE114 EAST SAVANNAH, ATLANTA GA30314*, NULL. E) INSERT INTO CUSTOERS VALUE 3 (1011, MCGOVERN . , 'REE SE', 'P.O. BOX 18" , CHICAGO , INSERT INTO CUSTOERS VALUES ( 1 012 , . MCKENZIE . , .ATLLIAM. , . P. . BOX 971. , . BOSTON. , MA"02110. NULL. "NE'); INSERT INTO CUSTOERS VALUE 3 (1013, NGUYEN', 'NICHOLAS. , 357 WHITE EAGLE AVE- CLERMONTEL 34711, 100 E) INSERT INTO CUSTOMERS VALUES ( 1 012 , . MCKENZIE . , .ATLLIAM. , . P. . BOX 971. , . BOSTON. , 02110NULL, "NE') INSERT INTO CUSTOMERS VALUE (1013, "NGUYEN", "NICHOLAS 357 WHITE EAGLE AVE., CLERMONTEL 34711, 100 E) INSERT INTO CUSTOMERS VALUE (1014 LEEJASMINE*,P.O BOX 297CODYWY '82414' , NULL, N') ; INSERT INTO CUSTOMERS VALUE (1015 CHELL*, STEVE,P.O. BOX 77"MIAMIEL 33111*, NULL E INSERT INTO CUSTOMERS VALUE (101 DAUMMICHELL 9851231 LONG ROADBURBANK', CA INSERT INTO CUSTOMERS VALUE (1017"NELSON, "BECCA *.O. BOX 563"KAIMA200 91508. 1010. 'W'); MI INSERT INTO CUSTOMERS VALUE (1018"MONT IASA,GREG100B GRAND AVENUE"MACON". 4900 NULL, "N* GA INSERT INTO CUSTOMERS VALUE (1019 SMITH JENNIFER', O. BOX 1151" 3120NULL, E') MORR ISTOWN 07 962. 1003. 'NE INSERT INTO CUSTOMERS VALUE (1020EALAH', 'RENNETH', O. BOX 335*, TRENTON CREATE TAELE Orders (Order# NUMBER (4 } , Customer# NUMBER (4), OrderDate DATE NOT NULL, 8hipDate DATE 8hipstreet VARCHAR2 (18) ShipCity VARCHAR2 (15), 8hipstate VARCHAR2 (2), 8hip2ip VARCHAR2 (5) 8hipCost NUMBER (4,2), CON STRAINT CONSTRAINT orders_ordert _pl PRIMARY KEY (ordert) order cu, tomer# fk FORE IGN EEY (cu tomer# } REFERENCES customers(customer ); INSERT INTO ORDERS VALUES ( 1000, 100 5, TO DATE ( . 31-MAR-09" , DD-MON-YY , TO DATE 02- APR-09DD-MON-YY1201 ORANGE AVESEATTLE 98114 INSERT INTO ORDERS VALUES ( 1001 , 101 0,TO DATE ( ' 31-MAR-09" , 'DD-MON-YY), TO DATE 01- APR-09DD-MON-YY' 114 EAST 3 AVANNAHATLANIA GA 30314, 3.00) INSERT INTO ORDERS VALUES ( 1002, 101 1 , TO DATE ( 31-MAR-09" , "DD-MON-YY . } , TO DATE 01- APR-09DD-MON-YY,58 TILA CIRCLE"CHICAGO IL "005 3.00) 2. 00) INSERT INTO ORDERS VALUES ( 1003 , 1001, TO DATE ( . 01-APR-09" , 'DD-MON-YY), TO DATE 01- APR-09DD-MON-YY,958 MAGNOLIA LANE' 'EASTPOINTEL 3232B,4.00) INSERT INTO ORDERS VALUES ( 1004, 102 0, TO DATE ( . 01-APR-09" , 'DD-MON-YY), TO DATE 05- APR-09DD-MON-YY,51 ROUNDABOUT WAY*, TRENTONNJ'. 08601*, NULL) INSERT INTO ORDERS VALUES ( 1005 , 101 8, TO DATE ( . 01-APR-09" , 'DD-MON-YY , TO DATE 02- APR-09DD-MON-YY1008 GRAND AVENUEMACON",GA 3120,2.00) INSERT INTO ORDERS VALUE 8 (1006,1003,TO DATE 01-APR-09",DD-MON-YY) , TO DATE C02 APR-09DD-MON-YY,55BA CAPITOL HWY.'. TALLAHAS SEEEL 32307',2.00) INSERT INTO ORDERS VALUES ( 1007, 1007, TO DATE ( . 02-APR-09" , 'DD-MON-YY , TO DATE 04- APR-09","DD-MOM-YY.), .9153 MAIN STREET', 'AUSTIN', .TX 78710,7.00) INSERT INTO ORDERS VALUES ( 1008 , 1004, TO DATE ( . 02-APR-09" , 'DD-MON-YY . } , TO DATE 03- APR-09DD-MON-YY9B 21 SOUTH AVENUE*, EOISEID 83707,3.00) INSERT INTO ORDERS VALUE 8 (1009,1005,TO DATE 03-APR-09",DD-MON-YY) , TO DATE C05 APR-09DD-MON-YY,LI GHTENING RDEATTLE',W 98110NULL) INSERT INTO ORDERS VALUES ( 1010, 101 9, TO DATE ( 03-APR-09" , 'DD-MON-YY), TO DATE 04- APR-09DD-MON-YY,3B4 WRONG WAY HOMEMORRISTOWNNJ 0790',2.00) INSERT INTO ORDERS VALUES ( 1011 , 1010, TO DATE 03-APR-09" , 'DD-MON-YY), TO DATE 05- APR-09DD-MON-YY102 WEST LAFAYETTE ATLANTA*,GA 30311, 2.00) INSERT INTO ORDERS VALUE 8 (1012,1017,TO DATE 03-APR-09",DD-MON-YY), NULL, "1295 INDY AVENUE INSERT INTO ORDERS VALUES ( 1013, 1014, TO DATE 03-APR-09" , 'DD-MON-YY), TO DATE 04- APR-09DD-MON-YY718 MOUNTAIN RD.CODY" Y 82414', 2.00) INSERT INTO ORDERS VALUES ( 1014, 1007, TO DATE ( . 04-APR-09" , 'DD-MON-YY , TO DATE 05- APR-09","DD-MOM-YY'), . 9153 MAIN STREET', 'AUSTIN', .TX 78710,3.00) INSERT INTO ORDERS VALUES ( 1015, 102 0, TO DATE 04-APR-09" , 'DD-MON-YY), NULL,' 5 57 GLITTER 3T.', 'TRENTON . , .MJ', 8606", 2.00); INSERT INTO ORDERS VALUE 8 (1016,1003,TO DATE 04-APR-09",DD-MON-YY), NULL, 9901 SEMINOLE WAYTALLAHASSEEEL32307",2.00) 2 INSERT INTO EOOES VALUE 3 ("249178320','PAINLESS CHILD-REARING',TO DATE('17- JUL-04DD-MON-YV').5.48.00,89.95, 4-50. "FAMILY LIFE' INSERT INTO EOOES VALUE S 0299282519,'THE WOR WAY TO COOR ,TO DATE11- SEP-04DD-MON-YY,4,19.00,28.75, NULL, 'COORING INSERT INTO EOOES VALUE 3 ('B117949391.,'BIG BEAR AND LITTLE DOVE ',TO DA E('08- NOV-05', 'DD-MOM-YY' } , 5, 5.32,8.95, NULL, 'CHILDREN'); INSERT INTO EOOES VALUE S 0132149 871,"HON TO GET FASTER PIZ2A ,TO DATE '11- NOV-06','DD-MOM-YY' },4,17-85,29.95, 1.50, 'SELF HELP'); INSERT INTO EOOES VALUE S 9247381001,"HON TO MANAGE THE MANAGER, TO DATE 09- MAY-03DD-MON-YY' ,1, 15. 40,31.95, NULL, INSERT INTO EOOES VALUE S 2147428890,SHORTEST POEMS ,TO DATEC01-MAY-05 DD- MON-YY),5,21.85,39.95, NULL, 'LITERATURE*) BUSINE93 CREATE TAELE ORDERI TEMS ( Order Item# NUMBER (2), ISEN VARCHAR2 (10, Quant ity NUMBER (3) NOT NULL, PadEach NUMBER 5,2 } NOT NULL, CONSTRAINT order items-Pk PRIMARY KEY (order#, itent), CONSTRAINT ordertem orde r# fk FOREIGN KEY (order# } NUMBER (4), REFERENCES order, (order# CONSTRAINT orderitems isbn fk FOREIGN REY (isbn) REFERENCE3 books (isbn), CoNSTRAINT oderitems_quantity_ck CHECK (quantity>0) INSERT INTO ORDERITEMS VALUE (1000,1,3437212490 ,1,19.95); INSERT INTO ORDERITEMS VALUE (10011,9247381001,1,31.95) INSERT INTO ORDERITEMS VALUE (1001,2, 2491748 320",1, 85. 45) INSERT INTO ORDERITEMS VALUE (10021,BB43172113,2, 55.95) INSERT INTO ORDERITEMS VALUE (10031,BB43172113 *,1,55.95) INSERT INTO ORDERITEMS VALUE (1003,2,105 983119B1,30.95) INSERT INTO ORDERITEMS VALUE (1003,3,3437212490 ,1,19.95); INSERT INTO ORDERITEMS VALUE (10041,2491748 320,2, 85. 45) INSERT INTO ORDERITEMS VALUE (1005,1,2147428 890 ,1,39.95) INSERT INTO ORDERITEMS VALUE (100,1,995 9789321*,1,54. 50) INSERT INTO ORDERITEMS VALUE 3 (1007,1, 395 7136468,3, 72.15) INSERT INTO EOOKAUTHOR | VALUE 3 1059831193100) INSERT INTO BOOKAUTHOR VALUES (' 105 98 31 198,' P 100' } ; INSERT INTO BOOKAUTHOR VALUE0401140733J100 INSERT INTO BOOKAUTHOR VALUE 3981341710,"K100) INSERT INTO BOOKAUTHOR VALUES (' 884 3172 113,' P 105" } ; INSERT INTO BOOKAUTHOR VALUES (' 884 3172 113 ' , 'A100' } ; INSERT INTO BOOKAUTHOR VALUE 3 BB3172113"A105 INSERT INTO BOOKAUTHOR VALUE 3 3437212490B100) INSERT INTO BOOKAUTHOR VALUE 3 395713646BA100) INSERT INTO BOOKAUTHOR VALUES (' 191 5762 492" , "N100' } ; INSERT INTO BOOKAUTHOR VALUES (' 191 5762 492" , "N105" } ; INSERT INTO BOOKAUTHOR VALUE 9959789321J100 INSERT INTO BOOKAUTHOR VALUE 3 2491748 320"R100) INSERT INTO BOOKAUTHOR VALUE 3 2491748 320F100) INSERT INTO BOOKAUTHOR VALUE 3 2491748 320B100) INSERT INTO BOOKAUTHOR VALUE 3 02992825199100) INSERT INTO BOOKAUTHOR VALUE (8117949391R100 INSERT INTO BOOKAUTHOR VALUE 3 ('0132149871','3100'); INSERT INTO BOOKAUTHOR VALUES (' 924 7381 001 . , 'N100' } ; INSERT INTO BOOKAUTHOR VALUE214 742B890W105 CREATE TABLE promoti (Gift varchar2 (15) , on Maxr et il nurie r (5,2)); INSERT into promotion INSERT into promotion INSERT into promotion INSERT into promotion COMMIT: VALUES BOOEMAREER, 0. 12) VALUE BOOK LABELS, 12.01, 25) VALUES BOOE COVER, 25.01, 56) VALUES EREE SHIPPING5.01, 999. 99) 8.) Paste a screen shot of your results from question 7 9.) How would you show all the authors with a last name of "WHITE"? Make sure to just output the AuthorlD and LNAME. 10.)Paste a screen shot of your results from question 9 CREATE TAELE Cus tomers (Customer# NUMBER (4), LastName VAR CHAR 2 (10) NOT NULL FirstName VARCHAR2 (10) NOT NULL, Addre VARCHAR2 (20), City VARCHAR 2 (12). State VARCHAR2 (2), 2ip VARCHAR2 (5) Refer red NUMBER (4), Region CHAR (2) CONSTRAINT customers-cus tomert_pk CONSTRAINI cus tome_region ck PRIMARY KEY(cus tomer# }, CHECK (region IN ('N"NW", 'NE', 3',SE" INSERT INTO CUSTOERS VALUE 3 (1001, "MORALESBONITA P. EOX 651EASTPOINT EL32328NULL, E' INSERT INTO CUSTOERS VALUE 3 (1002, 'THOMPSON', 'RYAN', 'P-0. BOX 9835", 'SANTA MONICA 'A90404*, NULL, '; INSERT INTO CUSTOERS VALUE (1003 SMITH', 'LE ILAP.O BOX ETALLAHASSEE EL3230NULL, E' INSERT INTO CUSTOERS VALUE (1004IER3ONTHOMAS*, 9821 8OUTH AVENUE BOISE', 'ID , .837 07 . , NULL, "Ni"); INSERT INTO CUSTOERS VALUE (1005 GIRARD*, CINDY.O. BOX B51SEATTLE INSERT INTO CUSTOERS VALUE (100CRU2 MESHIA, 82 DIRT ROAD,ALBANYNY" 12211, NULL, 'NE INSERT INTO CUSTOERS VALUE (1007GIANa*, 'TAMMY',9153 MAIN STREET'AUSTIN TX78710 , 1003 ) INSERT INTO CUSTOERS VALUE 3 (1008, JONE 3 . , 'EENNETH', 'P-O. BOX 137', CHEYENNE', "NY' , . 8 2008" , NULL, 'N ') ; INSERT INTO CUSTOERS VALUE (1009EREZ, JORGE P.O BOX B564BURBANK', CA91510 ,1003. "*) INSERT INTO CUSTOERS VALUE (1010LUCASJARE114 EAST SAVANNAH, ATLANTA GA30314*, NULL. E) INSERT INTO CUSTOERS VALUE 3 (1011, MCGOVERN . , 'REE SE', 'P.O. BOX 18" , CHICAGO , INSERT INTO CUSTOERS VALUES ( 1 012 , . MCKENZIE . , .ATLLIAM. , . P. . BOX 971. , . BOSTON. , MA"02110. NULL. "NE'); INSERT INTO CUSTOERS VALUE 3 (1013, NGUYEN', 'NICHOLAS. , 357 WHITE EAGLE AVE- CLERMONTEL 34711, 100 E) INSERT INTO CUSTOMERS VALUES ( 1 012 , . MCKENZIE . , .ATLLIAM. , . P. . BOX 971. , . BOSTON. , 02110NULL, "NE') INSERT INTO CUSTOMERS VALUE (1013, "NGUYEN", "NICHOLAS 357 WHITE EAGLE AVE., CLERMONTEL 34711, 100 E) INSERT INTO CUSTOMERS VALUE (1014 LEEJASMINE*,P.O BOX 297CODYWY '82414' , NULL, N') ; INSERT INTO CUSTOMERS VALUE (1015 CHELL*, STEVE,P.O. BOX 77"MIAMIEL 33111*, NULL E INSERT INTO CUSTOMERS VALUE (101 DAUMMICHELL 9851231 LONG ROADBURBANK', CA INSERT INTO CUSTOMERS VALUE (1017"NELSON, "BECCA *.O. BOX 563"KAIMA200 91508. 1010. 'W'); MI INSERT INTO CUSTOMERS VALUE (1018"MONT IASA,GREG100B GRAND AVENUE"MACON". 4900 NULL, "N* GA INSERT INTO CUSTOMERS VALUE (1019 SMITH JENNIFER', O. BOX 1151" 3120NULL, E') MORR ISTOWN 07 962. 1003. 'NE INSERT INTO CUSTOMERS VALUE (1020EALAH', 'RENNETH', O. BOX 335*, TRENTON CREATE TAELE Orders (Order# NUMBER (4 } , Customer# NUMBER (4), OrderDate DATE NOT NULL, 8hipDate DATE 8hipstreet VARCHAR2 (18) ShipCity VARCHAR2 (15), 8hipstate VARCHAR2 (2), 8hip2ip VARCHAR2 (5) 8hipCost NUMBER (4,2), CON STRAINT CONSTRAINT orders_ordert _pl PRIMARY KEY (ordert) order cu, tomer# fk FORE IGN EEY (cu tomer# } REFERENCES customers(customer ); INSERT INTO ORDERS VALUES ( 1000, 100 5, TO DATE ( . 31-MAR-09" , DD-MON-YY , TO DATE 02- APR-09DD-MON-YY1201 ORANGE AVESEATTLE 98114 INSERT INTO ORDERS VALUES ( 1001 , 101 0,TO DATE ( ' 31-MAR-09" , 'DD-MON-YY), TO DATE 01- APR-09DD-MON-YY' 114 EAST 3 AVANNAHATLANIA GA 30314, 3.00) INSERT INTO ORDERS VALUES ( 1002, 101 1 , TO DATE ( 31-MAR-09" , "DD-MON-YY . } , TO DATE 01- APR-09DD-MON-YY,58 TILA CIRCLE"CHICAGO IL "005 3.00) 2. 00) INSERT INTO ORDERS VALUES ( 1003 , 1001, TO DATE ( . 01-APR-09" , 'DD-MON-YY), TO DATE 01- APR-09DD-MON-YY,958 MAGNOLIA LANE' 'EASTPOINTEL 3232B,4.00) INSERT INTO ORDERS VALUES ( 1004, 102 0, TO DATE ( . 01-APR-09" , 'DD-MON-YY), TO DATE 05- APR-09DD-MON-YY,51 ROUNDABOUT WAY*, TRENTONNJ'. 08601*, NULL) INSERT INTO ORDERS VALUES ( 1005 , 101 8, TO DATE ( . 01-APR-09" , 'DD-MON-YY , TO DATE 02- APR-09DD-MON-YY1008 GRAND AVENUEMACON",GA 3120,2.00) INSERT INTO ORDERS VALUE 8 (1006,1003,TO DATE 01-APR-09",DD-MON-YY) , TO DATE C02 APR-09DD-MON-YY,55BA CAPITOL HWY.'. TALLAHAS SEEEL 32307',2.00) INSERT INTO ORDERS VALUES ( 1007, 1007, TO DATE ( . 02-APR-09" , 'DD-MON-YY , TO DATE 04- APR-09","DD-MOM-YY.), .9153 MAIN STREET', 'AUSTIN', .TX 78710,7.00) INSERT INTO ORDERS VALUES ( 1008 , 1004, TO DATE ( . 02-APR-09" , 'DD-MON-YY . } , TO DATE 03- APR-09DD-MON-YY9B 21 SOUTH AVENUE*, EOISEID 83707,3.00) INSERT INTO ORDERS VALUE 8 (1009,1005,TO DATE 03-APR-09",DD-MON-YY) , TO DATE C05 APR-09DD-MON-YY,LI GHTENING RDEATTLE',W 98110NULL) INSERT INTO ORDERS VALUES ( 1010, 101 9, TO DATE ( 03-APR-09" , 'DD-MON-YY), TO DATE 04- APR-09DD-MON-YY,3B4 WRONG WAY HOMEMORRISTOWNNJ 0790',2.00) INSERT INTO ORDERS VALUES ( 1011 , 1010, TO DATE 03-APR-09" , 'DD-MON-YY), TO DATE 05- APR-09DD-MON-YY102 WEST LAFAYETTE ATLANTA*,GA 30311, 2.00) INSERT INTO ORDERS VALUE 8 (1012,1017,TO DATE 03-APR-09",DD-MON-YY), NULL, "1295 INDY AVENUE INSERT INTO ORDERS VALUES ( 1013, 1014, TO DATE 03-APR-09" , 'DD-MON-YY), TO DATE 04- APR-09DD-MON-YY718 MOUNTAIN RD.CODY" Y 82414', 2.00) INSERT INTO ORDERS VALUES ( 1014, 1007, TO DATE ( . 04-APR-09" , 'DD-MON-YY , TO DATE 05- APR-09","DD-MOM-YY'), . 9153 MAIN STREET', 'AUSTIN', .TX 78710,3.00) INSERT INTO ORDERS VALUES ( 1015, 102 0, TO DATE 04-APR-09" , 'DD-MON-YY), NULL,' 5 57 GLITTER 3T.', 'TRENTON . , .MJ', 8606", 2.00); INSERT INTO ORDERS VALUE 8 (1016,1003,TO DATE 04-APR-09",DD-MON-YY), NULL, 9901 SEMINOLE WAYTALLAHASSEEEL32307",2.00) 2 INSERT INTO EOOES VALUE 3 ("249178320','PAINLESS CHILD-REARING',TO DATE('17- JUL-04DD-MON-YV').5.48.00,89.95, 4-50. "FAMILY LIFE' INSERT INTO EOOES VALUE S 0299282519,'THE WOR WAY TO COOR ,TO DATE11- SEP-04DD-MON-YY,4,19.00,28.75, NULL, 'COORING INSERT INTO EOOES VALUE 3 ('B117949391.,'BIG BEAR AND LITTLE DOVE ',TO DA E('08- NOV-05', 'DD-MOM-YY' } , 5, 5.32,8.95, NULL, 'CHILDREN'); INSERT INTO EOOES VALUE S 0132149 871,"HON TO GET FASTER PIZ2A ,TO DATE '11- NOV-06','DD-MOM-YY' },4,17-85,29.95, 1.50, 'SELF HELP'); INSERT INTO EOOES VALUE S 9247381001,"HON TO MANAGE THE MANAGER, TO DATE 09- MAY-03DD-MON-YY' ,1, 15. 40,31.95, NULL, INSERT INTO EOOES VALUE S 2147428890,SHORTEST POEMS ,TO DATEC01-MAY-05 DD- MON-YY),5,21.85,39.95, NULL, 'LITERATURE*) BUSINE93 CREATE TAELE ORDERI TEMS ( Order Item# NUMBER (2), ISEN VARCHAR2 (10, Quant ity NUMBER (3) NOT NULL, PadEach NUMBER 5,2 } NOT NULL, CONSTRAINT order items-Pk PRIMARY KEY (order#, itent), CONSTRAINT ordertem orde r# fk FOREIGN KEY (order# } NUMBER (4), REFERENCES order, (order# CONSTRAINT orderitems isbn fk FOREIGN REY (isbn) REFERENCE3 books (isbn), CoNSTRAINT oderitems_quantity_ck CHECK (quantity>0) INSERT INTO ORDERITEMS VALUE (1000,1,3437212490 ,1,19.95); INSERT INTO ORDERITEMS VALUE (10011,9247381001,1,31.95) INSERT INTO ORDERITEMS VALUE (1001,2, 2491748 320",1, 85. 45) INSERT INTO ORDERITEMS VALUE (10021,BB43172113,2, 55.95) INSERT INTO ORDERITEMS VALUE (10031,BB43172113 *,1,55.95) INSERT INTO ORDERITEMS VALUE (1003,2,105 983119B1,30.95) INSERT INTO ORDERITEMS VALUE (1003,3,3437212490 ,1,19.95); INSERT INTO ORDERITEMS VALUE (10041,2491748 320,2, 85. 45) INSERT INTO ORDERITEMS VALUE (1005,1,2147428 890 ,1,39.95) INSERT INTO ORDERITEMS VALUE (100,1,995 9789321*,1,54. 50) INSERT INTO ORDERITEMS VALUE 3 (1007,1, 395 7136468,3, 72.15) INSERT INTO EOOKAUTHOR | VALUE 3 1059831193100) INSERT INTO BOOKAUTHOR VALUES (' 105 98 31 198,' P 100' } ; INSERT INTO BOOKAUTHOR VALUE0401140733J100 INSERT INTO BOOKAUTHOR VALUE 3981341710,"K100) INSERT INTO BOOKAUTHOR VALUES (' 884 3172 113,' P 105" } ; INSERT INTO BOOKAUTHOR VALUES (' 884 3172 113 ' , 'A100' } ; INSERT INTO BOOKAUTHOR VALUE 3 BB3172113"A105 INSERT INTO BOOKAUTHOR VALUE 3 3437212490B100) INSERT INTO BOOKAUTHOR VALUE 3 395713646BA100) INSERT INTO BOOKAUTHOR VALUES (' 191 5762 492" , "N100' } ; INSERT INTO BOOKAUTHOR VALUES (' 191 5762 492" , "N105" } ; INSERT INTO BOOKAUTHOR VALUE 9959789321J100 INSERT INTO BOOKAUTHOR VALUE 3 2491748 320"R100) INSERT INTO BOOKAUTHOR VALUE 3 2491748 320F100) INSERT INTO BOOKAUTHOR VALUE 3 2491748 320B100) INSERT INTO BOOKAUTHOR VALUE 3 02992825199100) INSERT INTO BOOKAUTHOR VALUE (8117949391R100 INSERT INTO BOOKAUTHOR VALUE 3 ('0132149871','3100'); INSERT INTO BOOKAUTHOR VALUES (' 924 7381 001 . , 'N100' } ; INSERT INTO BOOKAUTHOR VALUE214 742B890W105 CREATE TABLE promoti (Gift varchar2 (15) , on Maxr et il nurie r (5,2)); INSERT into promotion INSERT into promotion INSERT into promotion INSERT into promotion COMMIT: VALUES BOOEMAREER, 0. 12) VALUE BOOK LABELS, 12.01, 25) VALUES BOOE COVER, 25.01, 56) VALUES EREE SHIPPING5.01, 999. 99)
