In an SQL Query,the Built-In Functions SUM and AVG Work

question 97

Multiple Choice

In an SQL query,the built-in functions SUM and AVG work with columns containing data of which of the following data types?

• A)Integer
• B)Numeric
• C)Char
• D)A and B
• E)A,B,and C

---

Definitions:

Ending Inventory

The total value of all unsold goods remaining at the end of an accounting period.

Recent Invoices

The latest billing statements or documents issued by a seller to a buyer, relating to a sale transaction and indicating the products, quantities, and agreed prices.

Full Disclosure Principle

The accounting principle that requires companies to fully disclose on their financial reports changes in accounting procedures and methods along with effects of the change as well as justification for change.

Inventory Valuation Method

The approach used to assess and report the value of a company's inventory, including methods such as FIFO (First In, First Out), LIFO (Last In, First Out), and average cost.