What is the sum of ages for men?
select sum(age) from person where gender = 'male'
What about the average?
select avg(age) from person where gender = 'male'
What is the average for each job?
select avg(age) from person where gender = 'male' group by job