# snagged from https://github.com/sriniiyer/nl2sql/blob/652edf4814dce2cddf1661e05a18602161c65e8f/data/geo/geo_dev.sql under the <something licence>
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 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 state.area FROM state WHERE state.state_name='texas';
SELECT state.population FROM state WHERE state.state_name='washington';
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='virginia';
SELECT state.area FROM state WHERE state.state_name='california';
...
Please add a LICENCE file to your repo.
I would like to know if I can copy some parts of this repo into my own code . Specifically, I am considering copying https://github.com/sriniiyer/nl2sql/blob/master/data/geo/geo_dev.sql into my project https://github.com/klahnakoski/mo-sql-parsing this would like something like:
Thank you