Which of the following queries will produce a different result set?

The following SQL query is given:

SELECT b. title, s. edition
FROM book b, in _ stock s
WHERE b. isbn = s. isbn and s. Iib_name = 'cao_Library' and
        NOT EXISTS (SELECT * FROM  in_stock i WHERE i.lib_name = ' Evans_Library and i. quantity > s. quantity);

Which of the following queries will produce a different result set?

(A) SELECT b.title, s.edition
       FROM book b, in_stock s
       WHERE b.isbn = s.isbn and s. Iib_name ' cao_Library' and s.quantity
       NOT IN (SELECT distinct quantity

                         FROM in_stock i WHERE i.lib_name = 'Evans_Library');

(B) SELECT b.title, S.edition

       FROM book b, in_stocks S

       WHERE b.iston = s.iston and s.Iib_name = 'cao_Library'  AND s.quantity >                      (SELECT max (quantity)

              FROM instock i

              WHERE i.Iib_name = ' Evans_Library');

(C) SELECT b.title, s. edition
       FROM book b, in_stock S
       WHERE b. isbn = s. isbn and s. Iib_name = 'cao_Library' and
            S. quantity > ALL (SELECT quantity FROM in_stock i
            WHERE i.Iib_name = 'Evans Library’);

(D) None of the above.

A
B
C
D
0Comment