Database: geo
Question: show major cities in kansas
SQL:
SELECT city_name FROM city WHERE population  >  150000 AND state_name  =  "kansas";