Question Completion Status: Question 2 . PUBLISHER PNO PNAME BEGIN DATE 10 PEARSON MC-GRAW-HILL 11 12-May-06 12-Jun-08 12-Aug-02 7-Jul-04 12 WILEY 13 OXFORD BOOK BNO BNAME PRICE PER DAY 500 101 ORACLE 102 1000 103 DEVELOPER C SHARP MANAGEMENT 2500 104 150 WID WNAME 1000 REHAN WRITER DOMAIN CHEIF WRITER ID COMPUTER 1001 COMUPTER 1003 SCIENCE 1003 CONIPUTER ATEF 1001 1002 1003 HISHAM KHALID PUBLISH WIDBNOPNO PUB TYPE PUBLISH DATE QUANTITY 1000 101 10 BOOK 10-May-08 15 1001 102 13 BOOK 20-May-10 20 1002 103 12 JOUNAL 1 Jun 07 1003 102 10 BOOK 20-May-10 120 1000 103 12 JOURNAL 12-Jan-12 10 Examine the table : Display the PName, WName, Chief Writer_Name, BName, Publish_date, Quantity and Total_Price which will calculate the total price for each publication PNAME WNAME CHIEF WRITER NAMEBNAME PUBLISH_DATE QUANTITYTOTAL_PRICE PEARSON REHAN ATEF ORACLE 10-May-08 15 7500 OXFORD ATEF KHALID DEVELOPER 20-May-10 20 20000 WILEY HISHAM KHALID C SHARP 1-Jun-07 3 12500 WILEY REHAN ATEF C SHARP 12-Jun-12 10 25000 MARK ALL THE CORRECT ANSWER Question Completion Status: MARK ALL THE CORRECT ANSWER SELECT P.PNAME MILITER WAME, W2.NAME CUTEP WRITER NAME, 1.RAME, VO POBLUSE_DATE, PO.QUANTITY PO. QUANTITY. B. PRICE_PER_DAY TOTAL PRICK FROM WHITER, POLISH PO, PUBLISHER BOOK, MILITER W2 WIRE WILITER.MID - PUWID AND P.PNO - PU.PNO AND NO PUENO AND WILTER.CHRIY WRITER ID - 2. WID SELECT P.PRAME, W.WNAME,W2. WNAME CHTEP WRITER, B. ENAME, PO. PUBLISH DATE, PU, QUANTITY POQUANTITY.PRECHPA_DAY TOTAL PRICE FROM WRITER W, PUBLISH PU . PUBLISHER P BOOK B, WRITER W2 WHERE W.WID - PU.WID AND P.PNO - W.PNO AND W.BNO PU.BNO AND W.CHRIF WRITER ID - W2.WID SELECT P.PNAME W WAME W2 WNAME CHIRP_WRITER B. NASCE PU. PUBLISH DATE PU QUANTITY, PU. QUANTITY. B.PRICE PER DAY TOTAL_PRICE 3 FROM WRITER W PUBLISH PU PUBLISHER P. BOOK B WRITER W2 WHERE W.WID - PUWID AND P.PNO - PUPNO AND B.BNO PUENO AND W2.CHEIF WRITER ID - W.WID SELECT P.PNAME W WYNAME - W2 WAMECHEY WRITER_NAME B. BNAME PU. PUBLISE DATE PU. QUANTITY PU. QUANTITY. B.PRICE PER DAY TOTAL PRICE 3401 Remaining Time: 39 minutes, 32 seconds. Less than half of the time remain Question Completion Status: - ROM WRITER W PUBLISH PU PUBLISHER P BOOK B, WRITER W2 2 WHERE W.WID - PO.WID AND P.PNO - W.PNO AND W.NO-PU.BNO AND W.CHIP_WRITER_ID - W2.WID SELECT P.PNAME, W. WAME W2.WNAME CETRY WRITER B. ENAME PU. PUBLISE DATE PU. QUANTITY, PO. QUANTITY B. PRICE_PER_DAY TOTAL_PRICE PROM WRITER W PUBLISH PU, PUBLISHER PBOOK B, WRITER W2 WHERE W.WID - PO.WID AND P.PNO - PU.PNO AND B.ENO PUENO AND W2.CHETY_WRITER_ID = W.WID SELECT P.PNAME W.WNAM W2.WNAME CHIEP WRITER NAME B. ENAME PU. PUBLISH DATE PU. QUANTITY, PU. QUANTITY. B.PRICE_PER_DAY TOTAL_PRICE PROM WRITER W PUBLISHI PU PUBLISHER PY BOOK B WRITER W2 WERE W.WID - PU.WID AND P.PNO - PU.PNO AND B.BNO PU, 20 AND W.CHEIP_WRITER_ID - W2.WID SELECT P.PNAMEW.WNAME W2.WNAME CHIRP_WRITER NAME, B. BRAME PO.PUBLISH_DATE, PU. QUANTITY, P.QUANTITY B. PRICH PER_DAY TOTAL_PRICEPROM WRITER W PUBLISH PUPUBLISHER PBOOK WRITER WWWHERE W.WID - P.WID AND P.PRO - PU.PNO AND B.BNO P.BNO AND W.CHETT_WRITER_ID - W2.WID SELECT P.PRAME WRITER WARE W2.WNAME CHIRP WRITER NASO RE 0 0 ENG SELECT P.PNAME W.WNAME W2.WNAME CHIEP WRITER NAME B.BNAME, PU.PUBLISIDATE, PU.QUANTI B.PRICE PER DAY TOTAL PRICEPROM WRITER W. PUBLISH PU, PUBLISHER P BOOK B, WRITER WWE W.WID = PU PU.PNO AND B.BNO P.BNO AND W.CHEIF WRITER ID - W2.WID 5. SELECT P.PNAME, WRITER.WNAME W2.WNAME CHIEF WRITER NAME B. ENAME PU.PUBLISH DATE, PU. QUANTITY, PU. QUANTITY. B.PRICE_PER_DAY TOTAL_PRICE 06. FROM WRITER W PUBLISH PUPUBLISHER P, BOOK B, WRITER W2 WHERE WRITER. WID = PU.WID AND P.PNO - PU.PNO AND B.BNO PU.ENO AND WRITER. CHEIF_WRITER_ID - W2.WID