Question: 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.
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.
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));
Step by Step Solution
3.30 Rating (156 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
