What is the last name alphabetically?
select name from person order by name desc limit 1
What is the occupation for Zach?
select job from person where name = 'Zach'
How old is the doctor named Zach?
select age from person where job = 'doctor' and name = 'Zach'