Database: geo
Question: what cities are located in texas
SQL:
SELECT city_name FROM city WHERE state_name  =  "texas";