human
Schema:
state (state_name, population, area, country_name, capital, density)
city (city_name, population, country_name, state_name)
border_info (state_name, border)
highlow (state_name, highest_elevation, lowest_point, highest_point, lowest_elevation)
lake (lake_name, area, country_name, state_name)
mountain (mountain_name, mountain_altitude, country_name, state_name)
river (river_name, length, country_name, traverse)
Please answer with SQL.
assistant
Sure, I understand.
human
how high is the highest point in the largest state
assistant
SELECT t2.highest_elevation FROM highlow AS t2 JOIN state AS t1 ON t1.state_name = t2.state_name WHERE t1.area = ( SELECT MAX ( area ) FROM state );
human
where is the highest mountain of the united states
assistant
SELECT state_name FROM mountain WHERE mountain_altitude = ( SELECT MAX ( mountain_altitude ) FROM mountain );
human
what is the highest mountain in the us
assistant
SELECT mountain_name FROM mountain WHERE mountain_altitude = ( SELECT MAX ( mountain_altitude ) FROM mountain );
human
which state has the highest elevation
assistant
SELECT state_name FROM highlow WHERE highest_elevation = ( SELECT MAX ( highest_elevation ) FROM highlow );
human
what mountains are in alaska
assistant
SELECT mountain_name FROM mountain WHERE state_name = 'alaska';
human
which is the highest peak not in alaska
assistant
SELECT mountain_name FROM mountain WHERE mountain_altitude = ( SELECT MAX( mountain_altitude ) FROM mountain WHERE state_name != "alaska" ) ;