Which of the following displays all books published by Publisher 1 with a retail price of at

Question:

Which of the following displays all books published by Publisher 1 with a retail price of at least $25.00?

a. SELECT * FROM books WHERE pubid = 1 AND retail >= 25;

b. SELECT * FROM books WHERE pubid = 1 OR retail >= 25;

c. SELECT * FROM books WHERE pubid = 1 AND WHERE retail > 25;

d. SELECT * FROM books WHERE pubid = 1, retail >= 25;

e. SELECT * FROM books WHERE pubid = 1, retail >= $25.00;

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: