Consider the following query:

Which of the following statements is not correct?

a. The query retrieves the product number, product name, and available quantity of each product thanks to the left outer join.

b. The query retrieves for each product the total ordered quantity.

c. The query result can never contain NULL values.

d. If we remove the GROUP BY statement and P.PRODNR, P.PRODNAME, P.AVAILABLE_QUANTITY from the SELECT statement, the query will result in one row containing the total outstanding ordered quantity over all products in column “ORDERED_QUANTITY”.

Transcribed Image Text:

SELECT P.PRODNR, P.PRODNAME, P.AVAILABLE_QUANTITY, SUM(L.QUANTITY) AS ORDERED_QUANTITY FROM PRODUCT AS P LEFT OUTER JOIN PO_LINE AS L ON (P.PRODNR=L.PRODNR) GROUP BY P.PRODNR