Consider the following query:

What is the result?

a. The query retrieves the product name of each product that has a supplier in New York or Washington.

b. The query retrieves the product name of each product that has both a supplier in New York and a supplier in Washington.

c. The query retrieves the product name of each product along with all possible supplier cities.

d. The query incorrectly combines every product name and supplier city.

Transcribed Image Text:

SELECT PRODNAME FROM PRODUCT WHERE PRODNR IN (SELECT PRODNR FROM SUPPLIES WHERE SUPNR IN (SELECT SUPNR FROM SUPPLIER WHERE SUPCITY= 'New York'))