Based on the following query:

SELECT        P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODE

FROM          PRODUCT

WHERE        P_QOH < P_MIN

      AND       P_MIN = P_REORDER’

      AND       P_REORDER = 50;

ORDER BY   P_QOH;

Use the recommendations given in Section 11-5b to rewrite the query to produce the required results more efficiently.