CREATE TABLE person (name VARCHAR2, job VARCHAR2, age NUMBER)
CREATE TABLE Person (name VARCHAR2, job VARCHAR2, age NUMBER)

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'