find the average age
select avg ( age ) from person
how many are female
select count ( * ) from person where gender = "female"
find the number of people whose age is greater than all engineers
select count ( * ) from person where age > ( select max ( age ) from person where job = 'engineer' )