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:

Cost of Goods Sold

Cost of Goods Sold is the total of all expenses directly related to the manufacturing or purchasing of products that a company sells during a period.

Days in Receivables

Days in Receivables, often referred to as Days Sales Outstanding (DSO), measures the average number of days it takes a company to collect payment after a sale has been made.

Accounts Receivable

This term refers to the money that is owed to a company by its customers for goods or services that have been delivered but not yet paid for.

Credit Sales

Sales made by a business where payment is delayed, allowing the buyer to purchase goods or services on credit.