SQL Function: AVG()

Definition:

Return the average of numerical values.

---

Command Syntax:

AVG(field_name)

---

Command Example:

Table STUDENT

SID	SNAME	CLASS	CNO	MARK
010122	Chris Wong	1A	5	19.4
010141	Gabe Lin	1C	6	35.6
010142	Nico Lin	1C	7	34.8
010133	Amy Chan	2D	12	-97.5
010156	Betty Chan	2E	9	NULL

Input:

SELECT AVG(MARK) AS Result FROM STUDENT;

Output:

Result
-1.925

---

‘AVG!=AdVenture Game’By secondary 6 student