what is the name of all males?
select name from person where gender = 'male'
what is the age of Bob?
select age from person where name = 'Bob'
who is a doctor?
select name from person where job = 'doctor'