What city does Alice live in?
select city from person where name = "Alice"
What gender is Alice?
select gender from person where name = "Alice"
What job does Bob do?
select job from person where name = "Bob"
How old is Bob?
select age from person where name = "Bob"
Where does he live?
select city from person where name = "Bob"
How many males are there?
select count ( * ) from person where gender = "male"
Who is the oldest person?
select name from person order by age desc limit 1
How old is the doctor named Zach?
select age from person where name = "Zach"
How many male engineers are there?
select count ( * ) from person where gender = "male" and job = "engineer"