Which of the following lists all books published before June 2, 2004 and all books published by

Question:

Which of the following lists all books published before June 2, 2004 and all books published by Publisher 4 or in the Fitness category?

a. SELECT * FROM books WHERE category = 'FITNESS' OR pubid = 4 AND pubdate < '06-02-2004';

b. SELECT * FROM books WHERE category = 'FITNESS' AND pubid = 4 OR pubdate < '06-02-2004';

c. SELECT * FROM books WHERE category = 'FITNESS' OR (pubid = 4 AND pubdate < '06-02-2004');

d. SELECT * FROM books WHERE category = 'FITNESS' OR pubid = 4, pubdate < '06-02-04';

e. None of the above

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: