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