CREATE TABLE person (name VARCHAR, job VARCHAR, age INT)
CREATE TABLE Person (name VARCHAR, job VARCHAR, age INT)

Who is the oldest person whose job is student?
SELECT name FROM person WHERE job = 'student' AND age = (SELECT MAX(age) FROM person WHERE job = 'student')
SELECT "name" FROM "person" WHERE "age" = (SELECT MAX("age") FROM "person" WHERE "job" = 'student') AND "job" = 'student'