Which student is older than the average age. | Do you want their id or last name or first name? | The first name for the student older than the average age.
select fname from student where age >  (  SELECT avg ( age )  FROM STUDENT ) 
older than the average age refers to age > AVG(age); first name refers to selecting fname;