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...
Modify the shar program presented in this chapter to handle directories: If the user specifies a directory instead of a file, it will archive every file within that directory and create the directory as needed when the archive is unpacked.
What will be an ideal response?
Computer Science & Information Technology
Describe the difference in the call statement if a class’ public member function
What will be an ideal response?
Computer Science & Information Technology
The ____ Lasso tool functions like the Lasso tool, but it does so with straight lines.
A. Magic B. Magnetic C. Polygonal D. Elliptical
Computer Science & Information Technology
The ________ area contains the formulas which are dependent on values found elsewhere in the sheet
Fill in the blank(s) with correct word
Computer Science & Information Technology