Database: geo
Question: what state has the largest urban population
SQL:
SELECT state_name FROM city GROUP BY state_name ORDER BY SUM ( population ) DESC LIMIT 1;