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.
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
Step by Step Solution
3.60 Rating (150 Votes )
There are 3 Steps involved in it
e No... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12126e6e_716415.pdf
180 KBs PDF File
1803_60b8c12126e6e_716415.docx
120 KBs Word File
