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