Contents of the ORDERS Table​

question 131

Multiple Choice

Contents of the ORDERS table​

-​Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?

• A) ​SELECT COUNT(DISTINCT(customer#)) FROM orders;
• B) ​SELECT COUNT(*) FROM orders;
• C) ​SELECT customer#,COUNT(customer#) FROM orders GROUP BY customer#;
• D) ​none of the above

---

Definitions:

Sales Commission

A fee or percentage of a sale amount paid to salespeople, typically as an incentive for sales performance.

Legal Fees

Costs incurred for legal services, which can sometimes be deductible on a tax return depending on the nature of the legal issue.

Casualty Loss

A casualty loss is a sudden, unexpected, or unusual loss of property resulting from events like natural disasters, accidents, or theft, which can be deductible under certain conditions for tax purposes.

Non-recognition

A tax principle allowing certain transfers or exchanges of property to occur without immediate tax consequences.