Give me the count for the students older than the average age.
select count ( fname )  from student where age >  (  SELECT avg ( age )  FROM STUDENT ) 
count for the students older than the average age refers to COUNT(*) WHERE age > AVG(age);