Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?
a. SELECT title FROM booksWHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35;
b. SELECT title FROM booksWHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35;
c. SELECT title FROM booksWHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35;
d. SELECT title FROM booksWHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);
c
You might also like to view...
When creating a note-card for the sources you will use in your speech, it is suggested that you record the title, _______, and subject on the top of each card.
Fill in the blank(s) with the appropriate word(s).
In a formal RFP, what is the executive summary used for?
A) To show an understanding for the client's needs B) To propose a solution that meets the needs listed in the RFP C) To propose a competitive fee D) To make information easy to find E) To provide a quick overview of the key ideas
Nonverbal communication does not include
a. chromatics. b. chronemics. c. haptics. d. semantics.
Which of the following is a true statement with regard to the paternalistic approach that some supervisors and managers use?
A. The manager or supervisor lets the employees determine what is best for them. B. The manager or supervisor has very little concern for the employer. C. The manager or supervisor believes he or she knows what is best for the employees. D. The manager or supervisor lets top management decide what is best for the employee.