name
select name from person order by age desc limit 1
How many friends does Alice have?
select count ( t2.friend ) from person as t1 join personfriend as t2 on t1.name = t2.friend where t2.name = 'Alice'
How many of those are women?
select count ( t2.friend ) from person as t1 join personfriend as t2 on t1.name = t2.friend where t2.name = 'Alice' and t1.gender = 'female'