Consider following query:

and the following statements:

1. For each product, the supplier number of the supplier who can supply the product for the cheapest price is retrieved.

2. For each product, the supplier number of the supplier who supplies the product for the highest price is retrieved.

3. For each product, exactly one tuple is returned.

4. For each product, more than one tuple can be returned. Which statements are true?

a. 1 and 3.

b. 1 and 4.

c. 2 and 3.

d. 2 and 4.

Transcribed Image Text:

SELECT P1.PRODNR, P1.PRODNAME, S1.SUPNR, S1.PURCHASE_PRICE FROM PRODUCT P1, SUPPLIES S1 WHERE P1.PRODNR = S1.PRODNR AND NOT EXISTS (SELECT * FROM PRODUCT P2, SUPPLIES S2 WHERE P2.PRODNR = S2.PRODNR AND P1.PRODNR = P2.PRODNR AND S1.PURCHASE_PRICE> S2.PURCHASE_PRICE)