Question: The following SQL querySELECT DISTINCT C . sidFROM Catalog CWHERE NOT EXISTS ( SELECT * FROM Parts PWHERE P . pid = C . pid
The following SQL querySELECT DISTINCT CsidFROM Catalog CWHERE NOT EXISTS SELECT FROM Parts PWHERE Ppid Cpid AND Pcolor 'Red'"has the equivalent English query: a The sids of suppliers who supply parts the color of which is anything but red. b The sids of suppliers who do not supply red parts.O c The sids of suppliers who supply every red part.O d The sids of suppliers who supply only red parts. None of the above
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
