Give me the count for the students younger than the average age.
select count ( fname )  from student where age <  (  SELECT avg ( age )  FROM STUDENT ) 
count of students = COUNT(fname); younger than the average age refers to age < (SELECT AVG(age) FROM student);