Which of the following queries selects the name of the supplier, corresponding order number, and total ordered quantity of the order that has the maximum total quantity ordered.

Transcribed Image Text:

a. SELECT R1.SUPNAME, POL1.PONR, SUM(POL1.QUANTITY) FROM SUPPLIER R1, PURCHASE_ORDER PO1, PO_LINE POL1 WHERE R1.SUPNR = PO1.SUPNR AND PO1.PONR= POL1.PONR GROUP BY POL1.PONR HAVING SUM(POL1.QUANTITY) >= ANY (SELECT SUM(POL2.QUANTITY) FROM SUPPLIER R2, PURCHASE_ORDER PO2, PO_LINE POL2 WHERE R2.SUPNR = PO2.SUPNR AND PO2.PONR= POL2.PONR GROUP BY POL2.PONR) b. SELECT R1.SUPNAME, POL1.PONR, SUM(POL1.QUANTITY) FROM SUPPLIER R1, PURCHASE_ORDER PO1, PO_LINE POL1 WHERE R1.SUPNR = PO1.SUPNR AND PO1.PONR= POL1.PONR GROUP BY POL1.PONR HAVING SUM(POL1.QUANTITY) <= ALL (SELECT SUM(POL2.QUANTITY) FROM SUPPLIER R2, PURCHASE_ORDER PO2, PO_LINE POL2 C. WHERE R2.SUPNR = PO2.SUPNR AND PO2.PONR= POL2.PONR d. GROUP BY POL2.PONR) SELECT R1.SUPNAME, POL1.PONR, SUM(POL1.QUANTITY) FROM SUPPLIER R1, PURCHASE_ORDER PO1, PO_LINE POL1 WHERE R1.SUPNR = PO1.SUPNR AND PO1.PONR= POL1.PONR GROUP BY POL1.PONR HAVING SUM(POL1.QUANTITY) >= ALL (SELECT SUM(POL2.QUANTITY) FROM SUPPLIER R2, PURCHASE_ORDER PO2, PO_LINE POL2 WHERE R2.SUPNR = PO2.SUPNR AND PO2.PONR= POL2.PONR GROUP BY POL2.PONR) SELECT R1.SUPNAME, POL1.PONR, SUM(POL1.QUANTITY) FROM SUPPLIER R1, PURCHASE_ORDER PO1, PO_LINE POL1 WHERE R1.SUPNR = PO1.SUPNR AND PO1.PONR= POL1.PONR GROUP BY POL1.PONR HAVING SUM(POL1.QUANTITY) <= ANY (SELECT SUM(POL2.QUANTITY) FROM SUPPLIER R2, PURCHASE_ORDER PO2, PO_LINE POL2 WHERE R2.SUPNR = PO2.SUPNR AND PO2.PONR= POL2.PONR GROUP BY POL2.PONR)