Question 22

Consider the following relational query on the above database:
SELECT S.sname
FROM Suppliers S
a WHERE S.sid NOT IN (SELECT C.sid 
     FROM Catalog C
     WHERE C.pid NOT IN (SELECT P.pid
             FROM Parts P
             WHERE P.color < > ‘blue’))
Assume that relations corresponding to the above schema are not empty. Which of the following is the correct interpretation of the above query?


Create a FREE account and get:

  • Download Maths Shortcuts PDF
  • Get 300+ previous papers with solutions PDF
  • 500+ Online Tests for Free

cracku

Boost your Prep!

Download App