What is the name of the oldest student?
CREATE TABLE personfriend (
    name text,
    friend text,
    year number
)

CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
)
SELECT name FROM person WHERE job = 'student' AND age = (SELECT MAX(age) FROM person WHERE job = 'student')
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the name of the oldest student? ### Input: CREATE TABLE personfriend (
    name text,
    friend text,
    year number
)

CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
) ### Response: SELECT name FROM person WHERE job = 'student' AND age = (SELECT MAX(age) FROM person WHERE job = 'student')