subject-Database management(my sql)

FROM PRODUCT P1, SUPPLES 51 WHERE P1. PRODNR = S1.PRODNR AND NOT EXISTS (SELECT * FROM PRODUCT P2, SUPPLES S2 WHERE P2.PRODNR - S2.PRODNR AND P1.PRODNR - P2.PRODNR AND \$1.PURCHASE.PRICE > S2.PURCHASE PRICE) Given following statements 1. For each product the supplier number is retrieved of the supolier who can supply the product for the cheapest prices 2. For each product, the supplier number is retrieved of the supplier who supplies the product for the highest price. 3. Fot each product, exactly one suple is returned 4. For each product, moie than one tuple can oe tetumed Which statements are true? a. Statements 2 and 3 b. Statements 2 and 4 c. Statements 1 and 4 d. Statements 1 and 3