Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?
a. SELECT FROM booksWHERE pubid = 1 OR pubid = 2 OR retail >= 42;
b. SELECT FROM booksWHERE pubid IN (1, 2) OR retail => 42;
c. SELECT FROM booksWHERE pubid = 1 AND pubid=2 OR retail >=42;
d. both a and b
.C
You might also like to view...
Various organizations publish summaries of selected ratios organized by industry for a sample of U.S. companies
a. True b. False Indicate whether the statement is true or false
Core applications are also called OLAP
Indicate whether the statement is true or false
A relatively homogenous group of prospective buyers that results from the market segmentation process is referred to as a(n) ________.
A. ultimate consumer B. preferred customer C. customer base D. target market E. market segment
A pattern of frequent tardiness is often a symptom of negative attitudes requiring managerial attention.
Answer the following statement true (T) or false (F)