The friends table has the columns and contents as shown:
Mysql> SELECT * FROM friends;
This statement was executed:
SELECT AVG (age) FROM friends
What value is returned?
A.
NULL
B.
10
C.
20
D.
0
What value is returned?
The friends table has the columns and contents as shown:
Mysql> SELECT * FROM friends;
This statement was executed:
SELECT AVG (age) FROM friends
What value is returned?
Answer is C.
http://www.mysqltutorial.org/mysql-avg/
Correct Answer is C … More useful info here >
http://stackoverflow.com/questions/14020924/strange-mysql-avg-anomaly-null-values
C