Find the name and age of the person who is a friend of both Dan and Alice.
select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Dan' intersect select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Alice'
Find the name and age of the person who is a friend of both Dan and Zach
select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Dan' intersect select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Zach'
Find the name and age of the person who is a friend of both Dan and Bob.
select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Dan' intersect select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Bob'
Find the name and age of the person who is a friend of both Bob and Zach.
select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Zach' intersect select t1.name, t1.age from person as t1 join personfriend as t2 on t1.name = t2.name where t2.friend = 'Bob'