
CREATE TABLE border_info (
	state_name TEXT, 
	border TEXT, 
	PRIMARY KEY (border, state_name), 
	FOREIGN KEY(border) REFERENCES state (state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)


CREATE TABLE city (
	city_name TEXT, 
	population INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT, 
	PRIMARY KEY (city_name, state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)


CREATE TABLE highlow (
	state_name TEXT, 
	highest_elevation TEXT, 
	lowest_point TEXT, 
	highest_point TEXT, 
	lowest_elevation TEXT, 
	PRIMARY KEY (state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)


CREATE TABLE lake (
	lake_name TEXT, 
	area DOUBLE DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT
)


CREATE TABLE mountain (
	mountain_name TEXT, 
	mountain_altitude INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT, 
	PRIMARY KEY (mountain_name, state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)


CREATE TABLE river (
	river_name TEXT, 
	length INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	traverse TEXT, 
	PRIMARY KEY (river_name), 
	FOREIGN KEY(traverse) REFERENCES state (state_name)
)


CREATE TABLE state (
	state_name TEXT, 
	population INTEGER DEFAULT NULL, 
	area DOUBLE DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	capital TEXT, 
	density DOUBLE DEFAULT NULL, 
	PRIMARY KEY (state_name)
)

CREATE TABLE border_info (
	state_name TEXT, 
	border TEXT, 
	PRIMARY KEY (border, state_name), 
	FOREIGN KEY(border) REFERENCES state (state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)

/*
2 rows from border_info table:
state_name	border

*/


CREATE TABLE city (
	city_name TEXT, 
	population INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT, 
	PRIMARY KEY (city_name, state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)

/*
2 rows from city table:
city_name	population	country_name	state_name

*/


CREATE TABLE highlow (
	state_name TEXT, 
	highest_elevation TEXT, 
	lowest_point TEXT, 
	highest_point TEXT, 
	lowest_elevation TEXT, 
	PRIMARY KEY (state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)

/*
2 rows from highlow table:
state_name	highest_elevation	lowest_point	highest_point	lowest_elevation

*/


CREATE TABLE lake (
	lake_name TEXT, 
	area DOUBLE DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT
)

/*
2 rows from lake table:
lake_name	area	country_name	state_name

*/


CREATE TABLE mountain (
	mountain_name TEXT, 
	mountain_altitude INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	state_name TEXT, 
	PRIMARY KEY (mountain_name, state_name), 
	FOREIGN KEY(state_name) REFERENCES state (state_name)
)

/*
2 rows from mountain table:
mountain_name	mountain_altitude	country_name	state_name

*/


CREATE TABLE river (
	river_name TEXT, 
	length INTEGER DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	traverse TEXT, 
	PRIMARY KEY (river_name), 
	FOREIGN KEY(traverse) REFERENCES state (state_name)
)

/*
2 rows from river table:
river_name	length	country_name	traverse

*/


CREATE TABLE state (
	state_name TEXT, 
	population INTEGER DEFAULT NULL, 
	area DOUBLE DEFAULT NULL, 
	country_name VARCHAR(3) DEFAULT '' NOT NULL, 
	capital TEXT, 
	density DOUBLE DEFAULT NULL, 
	PRIMARY KEY (state_name)
)

/*
2 rows from state table:
state_name	population	area	country_name	capital	density

*/
what is the tallest mountain in the united states
SELECT mountain_name FROM mountain WHERE mountain_altitude  =  ( SELECT MAX ( mountain_altitude ) FROM mountain );
[{'Nenhum': 'Nenhum resultado encontrado'}]