List all female names.
select name from person where gender = 'female'
How about males?
select name from person where gender = 'male'
What are the maximum ages for each gender?
select gender, max(age) from person group by gender
Who is the youngest male?
select name from person where gender = 'male' and age = (select min(age) from person where gender = 'male' )