Database: geo
Question: how many people live in the capital of texas
SQL:
SELECT population FROM city WHERE city_name  =  ( SELECT capital FROM state WHERE state_name  =  "texas" );