SELECT count(*) FROM people WHERE is_male  =  'F' AND age  >  30
How many female people are older than 30 in our record?
SELECT count ( * ) FROM people WHERE is_male = 'F ' AND age > 30
select count ( * ) from people where is_male = value and age > value
How many female people are older than 30 in our record ?