Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?
A) Avg
B) Sum
C) Count
D) Max

Question

Quizplus · Accepted Answer

The AVG function calculates the average value of a numeric column, which is exactly what Jenna needs to find the mean of all outstanding balances in the outBalances column.

Jenna Is Working on a Database That Stores a Company's