Consider the following query:

The query retrieves:

a. The name, number, and total outstanding orders of all suppliers that have outstanding orders.

b. The name, number, and total outstanding orders of all suppliers that have outstanding orders, except for the supplier(s) with the fewest outstanding orders.

c. The name, number, and total outstanding orders of the supplier with the most outstanding orders.

d. The name, number, and total outstanding orders of the supplier with the fewest outstanding orders.

Transcribed Image Text:

SELECT R1.SUPNAME, R1.SUPNR, COUNT(*) FROM PURCHASE_ORDER PO1, SUPPLIER R1 WHERE PO1.SUPNR = R1.SUPNR GROUP BY R1.SUPNR HAVING COUNT(*) >= ALL (SELECT COUNT(*) FROM PURCHASE_ORDER PO2, SUPPLIER R2 WHERE PO2.SUPNR = R2.SUPNR GROUP BY R2.SUPNR)