Consider the following SQL query:

This query selects:

a. The supplier name, supplier address, and supplier city of all suppliers who cannot supply any products.

b. The supplier name, supplier address, and supplier city of all suppliers who cannot supply all products.

c. The supplier name, supplier address, and supplier city of all suppliers who can supply at least one product.

d. The supplier name, supplier address, and supplier city of all suppliers who can supply all products.

Transcribed Image Text:

SELECT SUPNAME, SUPADDRESS, SUPCITY FROM SUPPLIER R WHERE NOT EXISTS (SELECT * FROM PRODUCT P WHERE EXISTS (SELECT * FROM SUPPLIES S WHERE R.SUPNR = S.SUPNR AND P.PRODNR = S.PRODNR));