Consider the following query:

The query selects:

a. The name and total number of outstanding orders of all suppliers that have at least one outstanding order.

b. The name and total number of outstanding orders of all suppliers.

c. The supplier name and order date of each of his/her outstanding orders.

d. The supplier name and order date of each of his/her outstanding orders. If a supplier does not have an outstanding order, she/he will be included in the output with a null value for the “SUMMARY” column.

Transcribed Image Text:

SELECT R.SUPNAME, (SELECT COUNT(PO.PODATE) FROM PURCHASE_ORDER PO WHERE R.SUPNR = PO.SUPNR) AS SUMMARY FROM SUPPLIER R