Question $47$

Given the following query:

SELECT PRODNR, AVG$($QUANTITY AS AVG$\_$QUANTITY

FROM PO$\_$LINE

GROUP BY PRODNR

HAVING SUM$($QUANTITY $<15$

What is the result?

$1-$The query returns the PRODNR and average QUANTITY of each purchase order that has less than $15$ purchase order lines.

$2-$ The query returns the PRODNR and average QUANTITY of each product that has less than $15$ purchase order lines.

$3-$ The query returns the PRODNR and average QUANTITY of each product that has less than $15$ orders.

$3-$ The query returns the PRODNR and average QUANTITY of each purchase order that has less than $15$ orders.