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
Question Posted: