Database: geo
Question: how many major cities are in states bordering nebraska
SQL:
SELECT COUNT ( city_name ) FROM city WHERE population  >  150000 AND state_name IN ( SELECT border FROM border_info WHERE state_name  =  "nebraska" );