(Note: SNO, PNO are primary keys)

Given the relation, Shipment(SNO, PNO, quantity), will the query below work without an error? Give your reasons. How would you fix the problem?

Select PNO, quantity, Avg(quantity)

from Shipment

group by PNO;