Functions

-----------------------------------------------------------------
Average

1. SELECT AVG(fee) FROM student;

2. SELECT id, name FROM student
WHERE fee>(SELECT AVG(fee) FROM student);
------------------------------------------------------
Count

1. SELECT COUNT(*) FROM student;