Below is an instruction that describes a task, paired with an input that provides further context. Write a response that appropriately completes the request.

### Instruction:

Convert text to sql: Find the name, age, and job title of persons who are friends with Alice for the longest years. | person : name , age , city , gender , job | personfriend : name , friend , year | personfriend.friend = person.name | personfriend.name = person.name | 

### Response:

select _ from _ where _ = ( select max ( _ ) from _ where _ ) | select person.name , person.age , person.job from person join personfriend on person.name = personfriend.name where personfriend.friend = 'Alice' and personfriend.year = ( select max ( year ) from personfriend where friend = 'Alice' )