Contents of BOOKS Table

question 109

Multiple Choice

Contents of BOOKS table
​
-​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 books WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35;
• B) ​SELECT title FROM books WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35;
• C) ​SELECT title FROM books WHERE (category = 'BUSINESS' OR category ='COMPUTER' )AND retail >35;
• D) ​SELECT title FROM books WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35);

---

Definitions:

Accounts Payable

Money owed by a business to its suppliers shown as a liability on the company's balance sheet.

Cash Receipts

The collection of money, including currency, checks, electronic transfers, and other forms of payment, for goods or services rendered.

Cash Payments

Money disbursed by a business for goods, services, or other obligations.

Accounts Receivable

Funds that customers owe to a company for products or services provided but not yet compensated for.