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