how many female persons are in the table
select count ( * ) from person where gender = "female"
please tell me alice friend name
select t2.friend from person as t1 join personfriend as t2 on t1.name = t2.name where t1.name = 'Alice'
what is the age of bob
select age from person where name = "Bob"