What are the names, ages, and jobs of all people who are friends with Alice for the longest amount of time?
CREATE TABLE personfriend (
    name text,
    friend text,
    year number
)

CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
)
SELECT T1.name, T1.age, T1.job FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Alice' AND T2.year = (SELECT MAX(year) FROM personfriend WHERE friend = 'Alice')
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 are the names, ages, and jobs of all people who are friends with Alice for the longest amount of time? ### 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 T1.name, T1.age, T1.job FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Alice' AND T2.year = (SELECT MAX(year) FROM personfriend WHERE friend = 'Alice')