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) Max B) Count C) Avg D) Sum
C
Computer Science & Information Technology
You might also like to view...
When the underlying data changes, a PivotTable automatically updates
Indicate whether the statement is true or false
Computer Science & Information Technology
Which statement is true about a non-static inner class?
a. It must implement an interface. b. It is accessible from any other class. c. It can only be instantiated in the enclosing class. d. It must be final if it is declared in a method scope. e. It can access private instance variables in the enclosing object.
Computer Science & Information Technology