CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

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 "age" = (SELECT MAX("age") FROM "person" WHERE "job" = 'student') AND "job" = 'student'