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')
Find the name, age, and job title of persons who are friends with Alice for the longest years.
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 ' )
select t1 . name , t1 . age , t1 . job from person as t1 join personfriend as t2 on t1 . name = t2 . name where t2 . friend = value and t2 . year = ( select max ( year ) from personfriend where friend = value )
Find the name , age , and job title of persons who are friends with Alice for the longest years .