Table: apprentice_season3
Columns: candidate
background
original_team
age
hometown
result

Question: Where is the real estate agent from?
SQL: SELECT "hometown" FROM apprentice_season3 WHERE "background" = 'Real Estate Agent'

Question: What background does the person from New york, New york, have?
SQL: SELECT "background" FROM apprentice_season3 WHERE "hometown" = 'New York, New York'

Question: How many backgrounds are there represented from Memphis, Tennessee?
SQL: SELECT COUNT("background") FROM apprentice_season3 WHERE "hometown" = 'Memphis, Tennessee'

Question: How many people had a prosecutor background?
SQL: SELECT COUNT("result") FROM apprentice_season3 WHERE "background" = 'Prosecutor'

Question: Where was Kristen Kirchner from?
SQL: SELECT "hometown" FROM apprentice_season3 WHERE "candidate" = 'Kristen Kirchner'