In which city do Dan friends reside
select t1.city from person as t1 join personfriend as t2 on t1.name = t2.name where t1.name = 'Dan'
Give me the full details of Zach
select * from person where name = 'Zach'