Consider following query:

The output of the query represents:

a. A table summarizing for each product the increase in stock after the ordered products are delivered.

b. A table summarizing for each product the decrease in stock after the ordered products are delivered.

c. A scalar, summarizing the total quantity of products in stock after all the ordered products are delivered.

d. A scalar, summarizing the decrease in total available quantity of all products after the ordered products are delivered.

Transcribed Image Text:

SELECT CS.CURRENT_STOCK - O.ORDERED AS NEW STOCK FROM (SELECT CURRENT_STOCK SUM(P.AVAILABLE_QUANTITY) AS FROM PRODUCT P) AS CS, (SELECT SUM(POL.QUANTITY) AS ORDERED FROM PO_LINE POL) AS O