which friend of zachs has the longest year relationship?
select t1.name from person as t1 join personfriend as t2 on t1.name = t2.friend where t2.name = 'Zach' and t2.year = ( select max ( year ) from personfriend where name = 'Zach' )
how old is dan?
select age from person where name = "Dan"
what city does Zach live?
select city from person where name = 'Zach'
what age is zach?
select age from person where name = 'Zach'
what is zach's job?
select job from person where name = 'Zach'