Show me the the name of all the representatives.
select name from representative
Only show me those from New York or Indiana.
select name from representative where state = "New York" or state = "Indiana"
What about their life spans?
select lifespan from representative where state = "New York" or state = "Indiana"