Database: geo
Question: how many cities are in texas
SQL:
SELECT COUNT ( city_name ) FROM city WHERE state_name  =  "texas";