Consider the following query: 

What is the result?

a. The query returns the PRODNR and average QUANTITY of each purchase order that has fewer than 15 purchase order lines.

b. The query returns the PRODNR and average QUANTITY of each product that has fewer than 15 purchase order lines.

c. The query returns the PRODNR and average QUANTITY of each product that has fewer than 15 orders.

d. The query returns the PRODNR and average QUANTITY of each purchase order that has fewer than 15 orders.

Transcribed Image Text:

SELECT PRODNR, AVG(QUANTITY) AS AVG_QUANTITY FROM PO_LINE GROUP BY PRODNR HAVING SUM(QUANTITY) <15