geo_train.sql

SELECT state.area FROM state WHERE state.state_name='texas';
SELECT city.city_name FROM city WHERE city.state_name='nebraska' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='nebraska');
SELECT city.population FROM city WHERE city.city_name='chicago';
SELECT state.population FROM state WHERE state.state_name='new mexico';
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population>150000;
SELECT city.state_name FROM city WHERE city.city_name='austin' AND city.population > 150000;
SELECT city.state_name FROM city WHERE city.city_name='kalamazoo';
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='hawaii';
SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='missouri';
SELECT city.state_name FROM city WHERE city.city_name='austin';
SELECT city.city_name FROM city WHERE city.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas') AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas'));
SELECT state.capital FROM state WHERE state.state_name='pennsylvania';
SELECT count(river.river_name) FROM river WHERE river.traverse NOT IN(SELECT state.state_name FROM state WHERE state.capital='albany');
SELECT city.population FROM city WHERE city.city_name='austin';
SELECT border_info.border FROM border_info WHERE border_info.state_name='ohio';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='alaska';
SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='iowa';
SELECT city.city_name FROM city WHERE city.population=(SELECT min(city.population) FROM city);
SELECT city.city_name FROM city WHERE city.state_name='hawaii' AND city.population=(SELECT min(city.population) FROM city WHERE city.state_name='hawaii');
SELECT river.river_name FROM river WHERE river.traverse='iowa' AND river.length=(SELECT min(river.length) FROM river WHERE river.traverse='iowa');
SELECT city.city_name FROM city WHERE city.population>150000 AND city.state_name=(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state ));
SELECT city.population FROM city WHERE city.city_name=(SELECT state.capital FROM state WHERE state.area=(SELECT max(state.area) FROM state,river WHERE river.traverse=state.state_name AND river.river_name='mississippi'));
SELECT river.river_name FROM river WHERE river.traverse='illinois' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='illinois');
SELECT river.river_name FROM river WHERE river.traverse='nebraska' AND river.length=(SELECT min(river.length) FROM river WHERE river.traverse='nebraska');
SELECT count(river.river_name) FROM river WHERE river.traverse='colorado';
SELECT city.population FROM city WHERE city.state_name='montana' AND city.population>150000;
SELECT state.population FROM state WHERE state.state_name='new york';
SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state);
SELECT river.length FROM river WHERE river.river_name='mississippi';
SELECT river.river_name FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT city.city_name FROM city WHERE city.state_name='wyoming' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='wyoming');
SELECT state.area FROM state WHERE state.state_name='maryland';
SELECT river.river_name FROM river WHERE river.traverse='colorado';
SELECT city.city_name FROM city WHERE city.state_name='michigan' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='michigan');
SELECT city.population FROM city WHERE city.city_name='new york';
SELECT border_info.state_name FROM state,border_info WHERE state.state_name=border_info.border AND state.population=(SELECT max(state.population) FROM state);
SELECT state.capital FROM state WHERE state.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas'));
SELECT count(river.river_name) FROM river WHERE river.traverse='texas';
SELECT city.city_name FROM city WHERE city.state_name='oklahoma' AND city.population>150000;
SELECT city.city_name FROM city WHERE city.population=(SELECT min(city.population) FROM city WHERE city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state))) AND city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state));
SELECT count(river.river_name) FROM river,state WHERE river.traverse=state.state_name AND state.state_name=(SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state ));
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='wyoming';
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT highlow.lowest_point FROM highlow WHERE highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow);
SELECT river.length FROM river WHERE river.river_name='mississippi';
SELECT river.river_name FROM river WHERE river.traverse='texas';
SELECT river.river_name FROM river WHERE river.traverse='arizona';
SELECT river.river_name FROM river GROUP BY(river.river_name) ORDER BY count(distinct river.traverse) DESC LIMIT 1;
SELECT border_info.border FROM border_info WHERE border_info.state_name='texas';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT city.state_name FROM city WHERE city.city_name='austin';
SELECT border_info.state_name FROM state,border_info,highlow WHERE(state.state_name=border_info.border)AND(border_info.border=highlow.state_name) AND highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow) ORDER BY state.area DESC LIMIT 1;
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='colorado';
SELECT state.population FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas') AND state.area=(SELECT max(state.area) FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas' ));
SELECT river.length FROM river WHERE river.river_name='mississippi';
SELECT state.population FROM state WHERE state.state_name='california';
SELECT border_info.border FROM border_info WHERE border_info.state_name='alaska';
SELECT state.state_name FROM state WHERE state.capital='austin';
SELECT city.population FROM city WHERE city.city_name='boston' AND city.state_name='massachusetts';
SELECT city.city_name FROM city WHERE city.state_name='colorado' AND city.population>150000;
SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT state.population FROM state WHERE state.state_name='maine';
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state));
SELECT border_info.border AS cnt FROM border_info GROUP BY border_info.border having count(1) = (SELECT max(cnt1) FROM (SELECT border_info.border, count(1) AS cnt1 FROM border_info GROUP BY border_info.border) tmp);
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT border_info.state_name FROM border_info WHERE border_info.border IN(SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state))) AND state.area=(SELECT max(state.area) FROM state WHERE state.state_name IN (SELECT border_info.state_name FROM border_info WHERE border_info.border IN(SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state))));
SELECT border_info.border FROM border_info WHERE border_info.state_name='new york';
SELECT state.capital FROM state,highlow WHERE state.state_name=highlow.state_name AND highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT mountain.mountain_name FROM mountain WHERE mountain.mountain_altitude=(SELECT max(mountain.mountain_altitude) FROM mountain);
SELECT state.state_name FROM state WHERE state.state_name IN (SELECT river.traverse FROM river WHERE river.river_name = 'mississippi' ) ORDER BY state.population DESC LIMIT 1;
SELECT distinct highlow.highest_point FROM highlow WHERE highlow.highest_elevation = (SELECT max(highlow.highest_elevation) FROM highlow);
SELECT city.city_name FROM city WHERE city.state_name='montana' AND city.population>150000;
SELECT highlow.highest_point FROM highlow WHERE highlow.highest_elevation = (SELECT max(highlow.highest_elevation) FROM highlow);
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='wisconsin';
SELECT count(river.river_name) FROM river;
SELECT city.state_name FROM city WHERE city.city_name='pittsburgh';
SELECT state.population FROM state WHERE state.state_name='nevada';
SELECT border_info.border FROM border_info WHERE border_info.state_name='maine';
SELECT river.river_name FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT distinct river.river_name FROM river WHERE river.length IN ( SELECT max(mx) FROM (  SELECT river.traverse, max(river.length) AS mx FROM river WHERE river.traverse IN ( SELECT border_info.state_name FROM border_info WHERE border_info.border IN (SELECT border_info.border FROM border_info GROUP BY border_info.border having count(1) = (SELECT max(cnt1) FROM (SELECT border_info.border, count(1) AS cnt1 FROM border_info GROUP BY border_info.border) tmp1) ) ) GROUP BY river.traverse ) tmp2 );
SELECT river.traverse FROM river WHERE river.length > 750 GROUP BY river.traverse ORDER BY count(1) DESC LIMIT 1;
SELECT distinct state.capital FROM state;
SELECT state.density FROM state WHERE state.state_name='south dakota';
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='oregon';
SELECT city.city_name FROM city WHERE city.state_name='virginia';
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT count(city.state_name) FROM city WHERE city.city_name='springfield';
SELECT count(city.state_name) FROM city WHERE city.city_name='rochester';
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='montana';
SELECT border_info.border FROM border_info WHERE border_info.state_name='hawaii';
SELECT border_info.border FROM border_info WHERE border_info.state_name='michigan';
SELECT count(city.city_name) FROM city;
SELECT city.state_name FROM city WHERE city.city_name='flint';
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT state.state_name FROM state WHERE state.population=(SELECT min(state.population) FROM state));
SELECT border_info.border FROM border_info WHERE border_info.state_name IN ( SELECT tmp1.state_name FROM (SELECT city.state_name, count(1) AS cnt1 FROM city GROUP BY city.state_name) tmp1 WHERE cnt1 = (SELECT max(cnt) FROM (SELECT count(1) AS cnt FROM city GROUP BY city.state_name) tmp))
SELECT border_info.border FROM border_info WHERE border_info.state_name='florida';
SELECT river.traverse FROM river,state WHERE river.traverse=state.state_name GROUP BY state.state_name ORDER BY count(river.river_name) DESC LIMIT 1 ;
SELECT river.river_name FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT lake.lake_name FROM lake WHERE lake.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas');
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas') AND state.area=(SELECT min(state.area) FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas' ));
SELECT river.river_name FROM river WHERE river.traverse='kansas';
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT river.river_name FROM river GROUP BY(river.river_name) ORDER BY count(distinct river.traverse) DESC LIMIT 1;
SELECT count(city.city_name) FROM city WHERE city.state_name='florida' AND city.population>150000;
SELECT river.river_name FROM river WHERE river.traverse='new york' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='new york');
SELECT river.length FROM river WHERE river.river_name='rio grande';
SELECT highlow.highest_elevation FROM highlow;
SELECT city.city_name FROM city WHERE city.state_name='pennsylvania';
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT state.population FROM state WHERE state.state_name='missouri';
SELECT state.population FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='texas';
SELECT count(river.traverse) FROM river WHERE river.river_name='mississippi';
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state)) AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state)));
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='oregon';
SELECT city.state_name FROM city WHERE city.city_name='springfield';
SELECT state.population/state.area FROM state WHERE state.state_name='pennsylvania';
SELECT river.river_name FROM river WHERE river.traverse='new mexico';
SELECT river.river_name FROM river WHERE river.traverse='arkansas';
SELECT count(river.traverse) FROM river WHERE river.river_name='colorado';
SELECT sum(state.population) FROM state;
SELECT state.population FROM state WHERE state.state_name='rhode island';
SELECT city.city_name FROM city WHERE city.state_name='illinois' AND city.population>150000;
SELECT state.state_name FROM state WHERE state.capital='dover';
SELECT river.traverse FROM river WHERE river.river_name='missouri';
SELECT city.state_name FROM city WHERE city.city_name='san jose';
SELECT river.river_name FROM river WHERE river.traverse='new york' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='new york');
SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT city.population FROM city WHERE city.city_name='san francisco';
SELECT border_info.border FROM border_info WHERE border_info.state_name='georgia';
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT river.river_name FROM river WHERE river.traverse='illinois' AND river.length>750;
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='florida'));
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='ohio';
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='tennessee';
SELECT state.population FROM state WHERE state.state_name='new york';
SELECT city.city_name FROM city WHERE city.state_name='virginia';
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT count(distinct border_info.state_name) FROM border_info;
SELECT city.state_name FROM city WHERE city.city_name='scotts valley';
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='montana';
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='new hampshire';
SELECT state.capital FROM state,border_info WHERE border_info.border=state.state_name AND border_info.state_name='texas';
SELECT state.state_name FROM state WHERE state.state_name NOT IN(SELECT border_info.state_name FROM border_info);
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='mississippi');
SELECT river.river_name FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT river.river_name FROM river WHERE river.traverse='mississippi' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='mississippi');
SELECT river.river_name FROM river WHERE river.traverse='colorado' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='colorado');
SELECT city.state_name FROM city WHERE city.city_name='new orleans';
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT city.population FROM city WHERE city.city_name='sacramento';
SELECT state.area FROM state WHERE state.state_name='maine';
SELECT max(distinct highlow.highest_elevation) FROM highlow WHERE highlow.state_name='texas';
SELECT city.city_name FROM city WHERE city.population>150000;
SELECT city.population FROM city WHERE city.state_name='wisconsin' AND city.population>150000;
SELECT state.population FROM state WHERE state.state_name='oregon';
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT state.capital FROM state WHERE state.state_name='texas';
SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state);
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name IN(SELECT state.state_name FROM state WHERE state.capital='des moines');
SELECT state.capital FROM state WHERE state.state_name='maryland';
SELECT river.river_name FROM river WHERE river.traverse='texas' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='texas');
SELECT state.area FROM state WHERE state.state_name='florida';
SELECT count(city.state_name) FROM city WHERE city.city_name='austin';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name IN(SELECT state.state_name FROM state WHERE state.capital='des moines');
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='iowa';
SELECT river.river_name FROM river WHERE river.traverse='california' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='california');
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='alaska';
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT state.state_name FROM state WHERE state.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas' ) ORDER BY state.population DESC LIMIT 1;
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='louisiana';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT count(state.state_name) FROM state;
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='colorado' AND border_info.border IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='new mexico');
SELECT state.state_name FROM state;
SELECT state.capital FROM state WHERE state.state_name='iowa';
SELECT river.traverse FROM river WHERE river.river_name='missouri';
SELECT state.area FROM state WHERE state.state_name='south carolina';
SELECT count(city.city_name) FROM city WHERE city.state_name='arizona' AND city.population>150000;
SELECT city.city_name FROM city WHERE city.population=(SELECT min(city.population) FROM city WHERE city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state))) AND city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT count(city.city_name) FROM city WHERE city.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='utah') AND city.population>150000;
SELECT lake.lake_name FROM lake WHERE lake.state_name='california';
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT sum(state.population) FROM state ,border_info WHERE state.state_name=border_info.border AND border_info.state_name='texas';
SELECT city.city_name FROM city WHERE city.state_name='north carolina' AND city.population>150000;
SELECT city.state_name FROM city,state WHERE city.state_name=state.state_name AND city.city_name='springfield';
SELECT lake.lake_name FROM lake;
SELECT river.traverse FROM river WHERE river.river_name='mississippi';
SELECT highlow.state_name FROM highlow WHERE highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow);
SELECT city.state_name FROM city WHERE city.city_name='indianapolis';
SELECT city.state_name FROM city WHERE city.city_name='des moines';
SELECT lake.lake_name FROM lake;
SELECT mountain.state_name FROM mountain WHERE mountain.mountain_name='mckinley';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='florida';
SELECT count(river.river_name) FROM river WHERE river.traverse='ohio' AND river.length>750;
SELECT river.traverse FROM river WHERE river.river_name='colorado';
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='mississippi');
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT distinct river.traverse FROM river WHERE river.length=(SELECT min(distinct river.length) FROM river);
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='california';
SELECT count(distinct river.traverse) FROM river WHERE river.length>750;
SELECT state.population FROM state WHERE state.state_name='illinois';
SELECT border_info.border FROM border_info WHERE border_info.state_name='rhode island';
SELECT city.population FROM city WHERE city.city_name=(SELECT state.capital FROM state WHERE state.state_name='georgia');
SELECT city.city_name FROM city WHERE city.state_name='minnesota' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='minnesota');
SELECT state.state_name FROM state left outer join border_info ON state.state_name = border_info.state_name WHERE state.state_name <> 'alaska' AND state.state_name <> 'hawaii' GROUP BY state.state_name having count(border_info.border) = (SELECT min(cnt) FROM (SELECT state.state_name, count(border_info.border) AS cnt FROM state left outer join border_info ON state.state_name = border_info.state_name WHERE state.state_name <> 'alaska' AND state.state_name <> 'hawaii' GROUP BY state.state_name) tmp);
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='ohio') AND state.area=(SELECT min(state.area) FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='ohio' ));
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT highlow.highest_point FROM highlow,state WHERE highlow.state_name=state.state_name AND state.area=(SELECT min(state.area) FROM state);
SELECT mountain.mountain_altitude FROM mountain WHERE mountain.mountain_name='mckinley';
SELECT state.state_name FROM state WHERE state.capital='sacramento';
SELECT count(river.river_name) FROM river WHERE river.traverse='texas';
SELECT city.population FROM city WHERE city.state_name='alaska' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='alaska');
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='mississippi';
SELECT max(highlow.highest_elevation) FROM highlow;
SELECT distinct state.state_name FROM border_info,state WHERE border_info.state_name='oklahoma' AND state.state_name=border_info.border AND state.population=(SELECT max(state.population) FROM border_info,state WHERE border_info.state_name='oklahoma' AND state.state_name=border_info.border);
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT river.traverse FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT state.state_name FROM state WHERE state.population=(SELECT min(state.population) FROM state);
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT city.state_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT mountain.state_name FROM mountain WHERE mountain.mountain_name='whitney';
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='texas';
SELECT river.river_name FROM river WHERE river.traverse='alaska' AND river.length=(SELECT min(river.length) FROM river WHERE river.traverse='alaska');
SELECT highlow.highest_point FROM highlow,state WHERE highlow.state_name=state.state_name AND state.state_name IN(SELECT state.state_name FROM state WHERE state.population=(SELECT min(state.population) FROM state));
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT state.state_name FROM state;
SELECT city.city_name FROM city WHERE city.state_name='alabama' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='alabama');
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT city.population FROM city WHERE city.city_name='denver';
SELECT border_info.border FROM border_info WHERE border_info.state_name='texas';
SELECT river.river_name FROM river WHERE river.river_name NOT IN(SELECT river.river_name FROM river WHERE river.traverse='tennessee');
SELECT river.river_name FROM river WHERE river.traverse IN (SELECT city.state_name FROM city WHERE city.population = (SELECT max(city.population) FROM city));
SELECT city.state_name FROM city WHERE city.city_name='austin';
SELECT state.population FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT river.river_name FROM river WHERE river.traverse IN (SELECT highlow.state_name FROM highlow WHERE highlow.lowest_elevation= (SELECT min(highlow.lowest_elevation) FROM highlow));
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT city.city_name FROM city WHERE city.state_name='oregon' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='oregon');
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='rhode island';
SELECT count(river.river_name) FROM river WHERE river.traverse='new york';
SELECT city.city_name FROM city WHERE city.population>150000;
SELECT mountain.mountain_name FROM mountain WHERE mountain.state_name='alaska';
SELECT city.population FROM city WHERE city.city_name='springfield' AND city.state_name='missouri';
SELECT border_info.border FROM border_info WHERE border_info.state_name='michigan';
SELECT max(tmp.states) FROM(SELECT count(distinct border_info.border) AS states, border_info.state_name FROM border_info GROUP BY border_info.state_name) AS tmp;
SELECT count(river.traverse) FROM river WHERE river.length>750;
SELECT state.density FROM state WHERE state.state_name='texas';
SELECT city.city_name FROM city WHERE city.state_name='ohio' AND city.population>150000;
SELECT state.state_name FROM state WHERE state.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas' ) ORDER BY state.area DESC LIMIT 1;
SELECT city.city_name FROM city WHERE city.state_name='arizona' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='arizona');
SELECT city.state_name FROM city WHERE city.city_name='boston';
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river)) AND state.area=(SELECT min(state.area) FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.length=(SELECT max(river.length) FROM river)));
SELECT river.river_name FROM river WHERE river.traverse='arkansas';
SELECT river.river_name FROM river WHERE river.traverse='louisiana';
SELECT river.river_name FROM river WHERE river.traverse='colorado';
SELECT river.traverse FROM river WHERE river.river_name='potomac';
SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state);
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='new mexico';
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi') AND state.area=(SELECT max(state.area) FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi'));
SELECT count(river.river_name) FROM river WHERE river.traverse IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='colorado');
SELECT city.state_name FROM city WHERE city.city_name='fort wayne';
SELECT distinct river.river_name FROM river WHERE NOT river.traverse='texas' AND river.length=(SELECT max(river.length) FROM river WHERE NOT river.traverse='texas');
SELECT city.population FROM city WHERE city.city_name='seattle';
SELECT count(river.river_name) FROM river WHERE river.traverse='colorado';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='texas';
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas') AND state.area=(SELECT max(state.area) FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas'));
SELECT river.river_name FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT river.length FROM river WHERE river.river_name='missouri';
SELECT count(city.city_name) FROM city WHERE city.population>150000;
SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='west virginia';
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT river.river_name FROM river GROUP BY(river.river_name) ORDER BY count(distinct river.traverse) DESC LIMIT 1;
SELECT count(city.city_name) FROM city;
SELECT river.traverse FROM river GROUP BY river.traverse ORDER BY count(1) DESC LIMIT 1;
SELECT river.river_name FROM river WHERE river.traverse='nevada';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city WHERE city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state))) AND city.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state));
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='florida';
SELECT city.city_name FROM city WHERE city.population IN (SELECT mx FROM (SELECT state.state_name , max(city.population) AS mx FROM state, city WHERE state.state_name = city.state_name AND state.state_name IN ( SELECT border_info.border FROM border_info GROUP BY border_info.border having count(1) = (SELECT max(cnt1) FROM (SELECT border_info.border, count(1) AS cnt1 FROM border_info GROUP BY border_info.border) tmp1)) GROUP BY state.state_name) tmp2);
SELECT river.river_name FROM river WHERE river.traverse='austin';
SELECT river.traverse FROM river,state WHERE river.traverse=state.state_name GROUP BY state.state_name ORDER BY count(river.river_name) DESC LIMIT 1 ;
SELECT state.state_name FROM state WHERE state.state_name NOT IN (SELECT river.traverse FROM river);
SELECT river.length FROM river WHERE river.river_name='rio grande';
SELECT state.population FROM state WHERE state.state_name='south dakota';
SELECT city.city_name FROM city WHERE city.state_name='california';
SELECT river.river_name FROM river WHERE river.traverse='pennsylvania' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='pennsylvania');
SELECT state.area FROM state WHERE state.state_name='california';
SELECT state.capital FROM state WHERE state.state_name='vermont';
SELECT state.population FROM state WHERE state.state_name='hawaii';
SELECT distinct river.length FROM river WHERE river.river_name = ( SELECT river_name FROM (SELECT river.river_name, count(1) AS cnt FROM river GROUP BY river.river_name ) tmp1 WHERE tmp1.cnt = (SELECT max (cnt) FROM (SELECT river.river_name, count(1) AS cnt FROM river GROUP BY river.river_name ) tmp2 ) );
SELECT state.state_name FROM state WHERE state.state_name NOT IN(SELECT border_info.state_name FROM border_info);
SELECT city.state_name FROM city WHERE city.city_name='houston';
SELECT river.traverse FROM river WHERE river.river_name='missouri';
SELECT river.traverse FROM river WHERE river.river_name='red';
SELECT count(city.city_name) FROM city WHERE city.population>150000;
SELECT city.city_name FROM city WHERE city.state_name='georgia' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='georgia');
SELECT count(river.river_name) FROM river,highlow WHERE river.traverse=highlow.state_name AND highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population>150000;
SELECT city.population FROM city WHERE city.city_name='boulder';
SELECT mountain.state_name FROM mountain WHERE mountain.mountain_altitude = (SELECT max(mountain.mountain_altitude) FROM mountain);
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT border_info.border FROM border_info GROUP BY border_info.border having count(1) = (SELECT max(cnt1) FROM (SELECT border_info.border, count(1) AS cnt1 FROM border_info GROUP BY border_info.border) tmp);
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='missouri';
SELECT city.population FROM city WHERE city.city_name='springfield' AND city.state_name='south dakota';
SELECT city.state_name FROM city GROUP BY city.state_name ORDER BY count(1) DESC LIMIT 1;
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT state.capital FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT count(city.city_name) FROM city WHERE city.state_name='montana';
SELECT highlow.highest_point FROM highlow WHERE(highlow.state_name=(SELECT river.traverse FROM river,state WHERE river.traverse=state.state_name GROUP BY state.state_name ORDER BY count(river.river_name) DESC LIMIT 1));
SELECT city.state_name FROM city WHERE city.city_name='springfield';
SELECT state.area FROM state;
SELECT city.city_name FROM city WHERE city.state_name='washington' AND city.population=(SELECT min(city.population) FROM city WHERE city.state_name='washington');
SELECT count(river.river_name) FROM river WHERE river.traverse='washington';
SELECT state.area FROM state WHERE state.state_name='texas';
SELECT border_info.border FROM border_info WHERE border_info.state_name='alaska';
SELECT count(river.traverse) FROM river WHERE river.river_name='colorado';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT river.traverse FROM river WHERE river.river_name='colorado';
SELECT city.city_name FROM city WHERE city.state_name='wyoming' AND city.population>150000;
SELECT count(river.river_name) FROM river WHERE river.traverse='alaska';
SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='texas' AND river.length=(SELECT min(river.length) FROM river WHERE river.traverse='texas');
SELECT state.area FROM state WHERE state.state_name='alaska';
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT river.length FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT river.river_name FROM river WHERE river.traverse='utah';
SELECT border_info.border FROM border_info WHERE border_info.state_name='south dakota';
SELECT state.capital FROM state WHERE state.state_name='georgia';
SELECT count(city.city_name) FROM city WHERE city.state_name='pennsylvania' AND city.population>150000;
SELECT highlow.lowest_elevation FROM highlow,river WHERE river.river_name='mississippi'  AND river.traverse=highlow.state_name;
SELECT count(distinct river.traverse) FROM river WHERE river.length=(SELECT min(distinct river.length) FROM river);
SELECT count(state.state_name) FROM state;
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='indiana';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT city.population FROM city WHERE city.city_name='boston';
SELECT state.state_name FROM state WHERE state.capital='columbus';
SELECT sum(state.population)/sum(state.area) FROM state;
SELECT city.city_name FROM city WHERE city.state_name='texas';
SELECT state.area FROM state WHERE state.state_name='new mexico';
SELECT state.population FROM state WHERE state.state_name='district of columbia';
SELECT river.river_name FROM river WHERE river.traverse='missouri';
SELECT river.traverse FROM river WHERE river.river_name='colorado';
SELECT state.population FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT city.state_name FROM city WHERE city.city_name='dallas';
SELECT state.population FROM state WHERE state.state_name='idaho';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT state.capital FROM state WHERE state.state_name='utah';
SELECT river.river_name FROM river WHERE river.traverse='montana';
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='texas';
SELECT city.state_name FROM city WHERE city.city_name='baton rouge';
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state )));
SELECT state.area FROM state WHERE state.state_name='idaho';
SELECT state.population FROM state WHERE state.state_name='montana';
SELECT state.capital FROM state,border_info WHERE border_info.border=state.state_name AND border_info.state_name='texas';
SELECT city.city_name FROM city WHERE city.state_name='wisconsin' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='wisconsin');
SELECT count(river.river_name) FROM river WHERE river.traverse='missouri';
SELECT state.state_name FROM state;
SELECT city.state_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT city.population FROM city WHERE city.city_name='kalamazoo';
SELECT state.capital FROM state WHERE state.state_name='maine';
SELECT state.capital FROM state WHERE state.state_name='texas';
SELECT state.density FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT city.state_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT count(river.traverse) FROM river WHERE river.river_name='mississippi';
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT city.city_name FROM city WHERE city.population>150000 AND city.state_name=(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT city.city_name FROM city WHERE city.state_name='california' AND city.population>150000;
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT state.area FROM state WHERE state.state_name='alaska';
SELECT count(river.traverse) FROM river WHERE river.river_name='missouri';
SELECT state.area FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='colorado';
SELECT state.capital FROM state WHERE state.state_name='washington';
SELECT sum(state.area) FROM state;
SELECT border_info.border FROM border_info WHERE border_info.state_name='arkansas';
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT highlow.state_name FROM highlow WHERE highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow);
SELECT state.population FROM state WHERE state.state_name='iowa';
SELECT count(city.city_name) FROM city WHERE city.state_name='oregon' AND city.population>150000;
SELECT lake.lake_name FROM lake;
SELECT state.population FROM state WHERE state.state_name='kansas';
SELECT border_info.border FROM border_info WHERE border_info.state_name IN (SELECT river.traverse FROM river WHERE river.length = (SELECT max(river.length) FROM river)  );
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT river.river_name FROM river WHERE river.traverse='alaska';
SELECT count(city.city_name) FROM city WHERE city.state_name='texas' AND city.population>150000;
SELECT border_info.border FROM border_info WHERE border_info.state_name='alabama';
SELECT city.population FROM city WHERE city.city_name='boulder';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='mississippi');
SELECT highlow.highest_elevation FROM highlow WHERE highlow.highest_point='guadalupe peak';
SELECT city.state_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT city.state_name FROM city WHERE city.city_name='san diego';
SELECT river.river_name FROM river WHERE river.traverse='alaska';
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='texas';
SELECT state.density FROM state WHERE state.population=(SELECT min(state.population) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='texas';
SELECT river.traverse FROM river WHERE river.river_name='mississippi';
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='south carolina';
SELECT count(distinct border_info.border) FROM border_info WHERE border_info.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT count(river.river_name) FROM river WHERE river.river_name='colorado';
SELECT state.density FROM state WHERE state.state_name='texas';
SELECT border_info.border FROM border_info WHERE border_info.state_name='michigan';
SELECT state.state_name FROM state, highlow WHERE state.capital = highlow.highest_point;
SELECT city.population FROM city WHERE city.city_name='boulder';
SELECT state.area FROM state WHERE state.state_name='texas';
SELECT city.population FROM city WHERE city.city_name=(SELECT state.capital FROM state WHERE state.area=(SELECT min(state.area) FROM state));
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation  > (SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name = 'texas');
SELECT city.population FROM city WHERE city.city_name=(SELECT state.capital FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT city.city_name FROM city WHERE city.state_name='delaware' AND city.population>150000;
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT river.river_name FROM river WHERE river.traverse='ohio';
SELECT highlow.lowest_point FROM highlow,state WHERE highlow.state_name=state.state_name AND state.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation  > (SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name = 'colorado');
SELECT state.capital FROM state WHERE state.state_name='indiana';
SELECT river.traverse FROM river WHERE river.river_name='colorado';
SELECT count(river.river_name) FROM river WHERE river.traverse='idaho';
(SELECT city.state_name FROM city WHERE city.population = (SELECT min(tmp.population) FROM (SELECT city.population FROM city, state WHERE state.capital = city.city_name) tmp) );
SELECT city.population FROM city WHERE city.city_name='montgomery';
SELECT state.population FROM state WHERE state.state_name='california';
SELECT state.area FROM state WHERE state.state_name='seattle';
SELECT city.city_name FROM city WHERE city.state_name='kansas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='kansas');
SELECT b1.border FROM border_info b1, border_info b2 WHERE b1.state_name = b2.border AND b2.state_name IN (SELECT state.state_name FROM state WHERE state.population = (SELECT max(state.population) FROM state));
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='new mexico');
SELECT state.capital FROM state WHERE state.state_name IN ( SELECT border_info.border FROM border_info GROUP BY border_info.border having count(1) = (SELECT max(cnt1) FROM (SELECT border_info.border, count(1) AS cnt1 FROM border_info GROUP BY border_info.border) tmp) );
SELECT state.area FROM state WHERE state.capital='albany';
SELECT city.city_name FROM city WHERE city.state_name='texas' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='texas');
SELECT highlow.lowest_point FROM highlow WHERE highlow.lowest_elevation = (SELECT min(highlow.lowest_elevation) FROM highlow);
SELECT city.state_name FROM city WHERE city.city_name='rochester';
SELECT state.capital FROM state,border_info WHERE border_info.border=state.state_name AND border_info.state_name='texas';
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT city.population FROM city WHERE city.city_name='austin' AND city.state_name='texas';
SELECT river.traverse FROM river WHERE river.river_name='mississippi';
SELECT city.population FROM city WHERE city.city_name='riverside';
SELECT state.capital FROM state WHERE state.state_name='alabama';
SELECT distinct highlow.highest_point FROM highlow WHERE highlow.highest_elevation = (SELECT max(highlow.highest_elevation) FROM highlow);
SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT border_info.border FROM border_info WHERE border_info.state_name='colorado';
SELECT max(state.area) FROM state;
SELECT state.state_name FROM state WHERE state.area=(SELECT min(state.area) FROM state WHERE state.state_name IN (SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas') ) AND state.state_name IN ((SELECT border_info.border FROM border_info WHERE border_info.state_name = 'texas'));
SELECT highlow.state_name FROM highlow WHERE highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow,river WHERE(river.river_name='mississippi') AND(river.traverse=highlow.state_name));
SELECT state.population FROM state WHERE state.state_name='montana';
SELECT city.city_name FROM city WHERE city.state_name='montana' AND city.population>150000;
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT border_info.border FROM border_info WHERE border_info.state_name IN(SELECT state.state_name FROM state WHERE state.capital='atlanta'));
SELECT highlow.lowest_elevation FROM highlow WHERE highlow.state_name='pennsylvania';
SELECT city.state_name FROM city WHERE city.city_name='denver';
SELECT state.population FROM state WHERE state.state_name='new hampshire';
SELECT count(city.city_name) FROM city WHERE city.state_name='louisiana';
SELECT count(river.river_name) FROM river WHERE river.traverse='texas' AND river.length > all(SELECT river.length FROM river WHERE river.river_name='red');
SELECT state.density FROM state WHERE state.area=(SELECT min(state.area) FROM state);
SELECT mountain.mountain_name FROM mountain WHERE mountain.mountain_altitude=(SELECT max(mountain.mountain_altitude) FROM mountain);
SELECT city.city_name FROM city WHERE city.state_name='wyoming' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='wyoming');
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name='kentucky';
SELECT state.capital FROM state, city WHERE state.capital = city.city_name AND city.population <= 150000;
SELECT highlow.highest_elevation FROM highlow,state WHERE highlow.state_name=state.state_name AND state.area=(SELECT max(state.area) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='delaware';
SELECT state.state_name FROM state WHERE state.density=(SELECT max(state.density) FROM state);
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT river.traverse FROM river WHERE river.river_name='mississippi';
SELECT city.city_name FROM city WHERE city.state_name='missouri' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='missouri');
SELECT sum(state.area) FROM state;
SELECT state.population FROM state WHERE state.state_name='new york';
SELECT max(highlow.highest_elevation) FROM highlow;
SELECT river.river_name FROM river WHERE river.traverse='maine';
SELECT mountain.state_name FROM mountain WHERE mountain.mountain_name='whitney';
SELECT highlow.highest_point,highlow.state_name FROM highlow WHERE highlow.lowest_elevation=0;
SELECT city.city_name FROM city;
SELECT city.population FROM city WHERE city.city_name='portland' AND city.state_name='maine';
SELECT highlow.highest_point FROM highlow,state WHERE highlow.state_name=state.state_name AND state.state_name IN(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT state.country_name FROM state WHERE state.state_name='new hampshire';
SELECT state.country_name FROM state WHERE state.state_name='massachusetts';
SELECT border_info.border FROM border_info WHERE border_info.state_name='iowa';
SELECT border_info.border FROM border_info WHERE border_info.state_name='alabama';
SELECT city.population FROM city WHERE city.city_name='spokane' AND city.state_name='washington';
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='louisiana';
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT state.capital FROM state,highlow WHERE state.state_name=highlow.state_name AND highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT river.river_name FROM river WHERE river.traverse='texas';
SELECT state.area FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT border_info.border FROM border_info WHERE border_info.state_name='kentucky';
SELECT river.river_name FROM river WHERE river.traverse='texas' AND river.length=(SELECT max(river.length) FROM river WHERE river.traverse='texas');
SELECT city.state_name FROM city GROUP BY city.state_name ORDER BY sum(city.population) DESC LIMIT 1;
SELECT state.population FROM state WHERE state.state_name='alabama';
SELECT state.state_name FROM state WHERE state.population=(SELECT max(state.population) FROM state);
SELECT city.population FROM city WHERE city.city_name='atlanta';
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT count(city.city_name) FROM city;
SELECT river.traverse FROM river WHERE river.river_name='mississippi';
SELECT state.state_name FROM state left outer join border_info ON state.state_name = border_info.state_name GROUP BY state.state_name having count(border_info.border) = (SELECT min(cnt) FROM (SELECT state.state_name, count(border_info.border) AS cnt FROM state left outer join border_info ON state.state_name = border_info.state_name GROUP BY state.state_name) tmp);
SELECT border_info.border FROM border_info WHERE border_info.state_name='california';
SELECT state.area FROM state WHERE state.state_name='california';
SELECT river.river_name FROM river;
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT river.traverse FROM river;
SELECT state.capital FROM state WHERE state.state_name='michigan';
SELECT border_info.border FROM border_info WHERE border_info.state_name='hawaii';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='new mexico';
SELECT river.river_name FROM river,border_info WHERE river.traverse=border_info.state_name AND border_info.border='tennessee' ORDER BY river.length DESC LIMIT 1;
SELECT count(city.city_name) FROM city WHERE city.city_name='austin';
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='colorado';
SELECT city.population FROM city WHERE city.city_name='austin';
SELECT city.city_name FROM city WHERE city.state_name='alaska' AND city.population=(SELECT min(city.population) FROM city WHERE city.state_name='alaska');
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT border_info.border FROM border_info WHERE border_info.state_name='wisconsin';
SELECT border_info.border FROM border_info WHERE border_info.state_name='arizona';
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT state.population FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='wyoming') AND state.population=(SELECT max(state.population) FROM state WHERE state.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='wyoming' ));
SELECT river.length FROM river WHERE river.river_name='colorado' AND river.traverse='texas';
SELECT river.river_name FROM river WHERE river.traverse='virginia';
SELECT state.population FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='mississippi');
SELECT count(city.state_name) FROM city WHERE city.city_name='springfield';
SELECT border_info.border FROM border_info WHERE border_info.state_name='kentucky';
SELECT state.state_name FROM border_info,state WHERE state.state_name=border_info.border AND border_info.state_name='california' AND state.area=(SELECT max(state.area) FROM border_info,state WHERE state.state_name=border_info.border AND border_info.state_name='california');
SELECT state.state_name FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='rio grande') AND state.area=(SELECT max(state.area) FROM state WHERE state.state_name IN(SELECT river.traverse FROM river WHERE river.river_name='rio grande'));
SELECT state.density FROM state WHERE state.capital='austin';
SELECT state.capital FROM state WHERE state.state_name='hawaii';
SELECT state.population FROM state WHERE state.state_name='arizona';
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT count(city.city_name) FROM city WHERE city.state_name='texas';
SELECT state.capital FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city,state WHERE city.city_name=state.capital);
SELECT river.length FROM river WHERE river.length=(SELECT min(river.length) FROM river);
SELECT city.population FROM city WHERE city.city_name=(SELECT state.capital FROM state WHERE state.state_name = 'texas');
SELECT city.population FROM city WHERE city.city_name='austin' AND city.state_name='texas';
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='alabama');
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT highlow.lowest_elevation FROM highlow WHERE highlow.lowest_point='death valley';
SELECT city.city_name FROM city WHERE city.state_name='rhode island' AND city.population>150000;
SELECT avg(state.population) FROM state;
SELECT city.city_name FROM city WHERE city.state_name='missouri' AND city.population>150000;
SELECT state.area FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT state.capital FROM state WHERE state.state_name='new hampshire';
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation>(SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='colorado');
SELECT highlow.state_name FROM highlow WHERE highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow);
SELECT state.area FROM state WHERE state.state_name='north dakota';
SELECT river.river_name FROM river WHERE river.traverse IN(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT river.traverse FROM river GROUP BY river.traverse ORDER BY count(1) DESC LIMIT 1;
SELECT distinct river.length FROM river WHERE river.river_name = ( SELECT river_name FROM (SELECT river.river_name, count(1) AS cnt FROM river GROUP BY river.river_name ) tmp1 WHERE tmp1.cnt = (SELECT max (cnt) FROM (SELECT river.river_name, count(1) AS cnt FROM river GROUP BY river.river_name ) tmp2 ) );
SELECT state.area FROM state WHERE state.state_name='massachusetts';
SELECT b1.border FROM border_info b1, border_info b2, border_info b3, border_info b4 WHERE b1.state_name = b2.border AND b2.state_name = b3.border AND b3.state_name = b4.border AND b4.state_name = 'texas';
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name=(SELECT state.state_name FROM state WHERE state.capital='boston');
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state);
SELECT state.capital FROM state WHERE state.state_name='texas';
SELECT city.city_name FROM city WHERE city.population>150000 AND city.state_name IN (SELECT river.traverse FROM river WHERE river.river_name IN (SELECT river.river_name FROM river WHERE river.traverse='virginia' AND river.length>750) );
SELECT state.population FROM state WHERE state.state_name='south dakota';
SELECT state.area FROM state WHERE state.state_name='new mexico';
SELECT state.state_name FROM state WHERE state.state_name NOT IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='texas');
SELECT count(city.city_name) FROM city WHERE city.state_name IN(SELECT border_info.border FROM border_info WHERE border_info.state_name='nebraska') AND city.population>150000;
SELECT state.state_name FROM state WHERE state.capital='salem';
SELECT count(border_info.border) FROM border_info WHERE border_info.state_name=(SELECT state.state_name FROM state WHERE state.area=(SELECT max(state.area) FROM state));
SELECT city.city_name FROM city WHERE city.population=(SELECT max(city.population) FROM city);
SELECT city.city_name FROM city WHERE city.state_name='california';
SELECT river.river_name FROM river WHERE river.traverse='oregon';
SELECT state.population FROM state WHERE state.state_name='minnesota';
SELECT sum(state.area) FROM state;
SELECT state.density FROM state WHERE state.state_name='wyoming';
SELECT city.city_name FROM city WHERE city.state_name='arkansas' AND city.population=(SELECT min(city.population) FROM city WHERE city.state_name='arkansas');
SELECT state.population FROM state WHERE state.state_name='texas';
SELECT state.population FROM state WHERE state.state_name='utah';
SELECT river.river_name FROM river WHERE river.length=(SELECT max(river.length) FROM river);
SELECT river.river_name FROM river WHERE river.traverse='illinois';
SELECT state.population FROM state WHERE state.state_name='texas';
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='kansas';
SELECT city.population FROM city WHERE city.city_name='dallas';
SELECT city.city_name FROM city WHERE city.state_name='texas';
SELECT city.state_name FROM city WHERE city.state_name='montana' AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name='montana');
SELECT city.city_name FROM city WHERE city.state_name IN(SELECT border_info.state_name FROM border_info WHERE border_info.border='california') AND city.population=(SELECT max(city.population) FROM city WHERE city.state_name IN(SELECT border_info.state_name FROM border_info WHERE border_info.border='california'));
SELECT highlow.lowest_point FROM highlow WHERE highlow.state_name='iowa';
SELECT river.traverse FROM river WHERE river.river_name='ohio';
SELECT highlow.lowest_point FROM highlow WHERE highlow.lowest_elevation = (SELECT min(highlow.lowest_elevation) FROM highlow);
SELECT river.river_name FROM river WHERE river.traverse IN ( SELECT highlow.state_name FROM highlow WHERE highlow.lowest_elevation=(SELECT min(highlow.lowest_elevation) FROM highlow));
SELECT lake.lake_name FROM lake WHERE lake.state_name='michigan';
SELECT city.population FROM city WHERE city.city_name='atlanta';
SELECT state.state_name FROM state WHERE state.population=(SELECT min(state.population) FROM state);
SELECT state.state_name FROM state WHERE state.density=(SELECT min(state.density) FROM state);
SELECT city.population FROM city WHERE city.city_name='seattle' AND city.state_name='washington';
SELECT state.state_name FROM state WHERE state.state_name NOT IN (SELECT border_info.state_name FROM border_info);
SELECT state.population FROM state WHERE state.state_name='district of columbia';
SELECT city.city_name FROM city WHERE city.state_name='kansas' AND city.population>150000;
SELECT state.population FROM state WHERE state.state_name='california';
SELECT river.river_name FROM river,highlow WHERE river.traverse=highlow.state_name AND highlow.highest_elevation=(SELECT max(highlow.highest_elevation) FROM highlow) ORDER BY river.length DESC LIMIT 1;
SELECT city.city_name FROM city WHERE city.population=(SELECT min(city.population) FROM city);
SELECT highlow.highest_point FROM highlow WHERE highlow.state_name='texas';
SELECT city.population FROM city WHERE city.city_name='boulder';
SELECT city.population FROM city WHERE city.city_name='boulder';
SELECT state.population FROM state WHERE state.state_name='washington';
SELECT highlow.highest_elevation FROM highlow WHERE highlow.state_name='delaware';