SELECT name FROM Person WHERE job  =  'student' AND age  =  (SELECT max(age) FROM person WHERE job  =  'student' )
What is the name of the oldest student?
SELECT name FROM Person WHERE job = 'student ' AND age = ( SELECT max ( age ) FROM person WHERE job = 'student ' )
select name from person where job = value and age = ( select max ( age ) from person where job = value )
What is the name of the oldest student ?