Count the number of people in the record.
select count(*) from people
How many are female?
select count(*) from people where is_male = 'F'
How many of them are older than 30?
select count(*) from people where is_male = 'F' and age > 30