Given the task to retrieve the numbers of all suppliers who can supply products 0832 and 0494, which query is correct?

Transcribed Image Text:

a. SELECT DISTINCT SUPNR FROM SUPPLIES WHERE PRODNR IN (0832, 0494) b. SELECT SUPNR FROM SUPPLIES WHERE PRODNR = 0832 UNION ALL SELECT SUPNR FROM SUPPLIES WHERE PRODNR = 0494 C. SELECT SUPNR FROM SUPPLIES WHERE PRODNR = 0832 INTERSECT SELECT SUPNR FROM SUPPLIES WHERE PRODNR = 0494 d. SELECT UNIQUE SUPNR FROM SUPPLIES WHERE PRODNR IN (0832, 0494)