Database: geo
Question: how many residents live in california
SQL:
SELECT population FROM state WHERE state_name  =  "california";