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