What is the average age of all males?
select avg ( age ) from person where gender = 'male'
What are all the jobs of males?
select job from person where gender = 'male'
What are the average ages of male engineers and male doctors?
select avg ( age ), job from person where gender = 'male' group by job