Database: geo
Question: how many states have a city called springfield
SQL:
SELECT COUNT ( state_name ) FROM city WHERE city_name  =  "springfield";