Find average employee commission. (a) Ignore nulls. (b) Do not ignore nulls.
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT AVG(Commission)
2 FROM employee;
AVG(COMMISSION)
---------------
14600
SQL> SELECT AVG(NVL(Commission, 0))
2 FROM employee;
AVG(NVL(COMMISSION,0))
----------------------
9125
```
You might also like to view...
Which of the following is NOT a component of using SNMP for network monitoring?
A. software agent B. MIB C. management station D. event log
Standard error stream outputs are directed to the stream objects _____or _____.
Fill in the blank(s) with the appropriate word(s).
Assessment of digital evidence is typically done by analyzing small samples that preserve the totality of the evidence
Indicate whether the statement is true or false.
_____ objects are extended by adding new methods to those object's prototypes.
A. Native B. Custom C. Host D. Base