CREATE TABLE country (id NUMBER, name CLOB)
CREATE TABLE league (id NUMBER, country_id NUMBER, name CLOB)
CREATE TABLE sqlite_sequence (name CLOB, seq CLOB)
CREATE TABLE player (id NUMBER, player_api_id NUMBER, player_name CLOB, player_fifa_api_id NUMBER, birthday CLOB, height NUMBER, weight NUMBER)
CREATE TABLE team (id NUMBER, team_api_id NUMBER, team_fifa_api_id NUMBER, team_long_name CLOB, team_short_name CLOB)
CREATE TABLE team_attributes (id NUMBER, team_fifa_api_id NUMBER, team_api_id NUMBER, date CLOB, buildupplayspeed NUMBER, buildupplayspeedclass CLOB, buildupplaydribbling NUMBER, buildupplaydribblingclass CLOB, buildupplaypassing NUMBER, buildupplaypassingclass CLOB, buildupplaypositioningclass CLOB, chancecreationpassing NUMBER, chancecreationpassingclass CLOB, chancecreationcrossing NUMBER, chancecreationcrossingclass CLOB, chancecreationshooting NUMBER, chancecreationshootingclass CLOB, chancecreationpositioningclass CLOB, defencepressure NUMBER, defencepressureclass CLOB, defenceaggression NUMBER, defenceaggressionclass CLOB, defenceteamwidth NUMBER, defenceteamwidthclass CLOB, defencedefenderlineclass CLOB)
CREATE TABLE player_attributes (id NUMBER, player_fifa_api_id NUMBER, player_api_id NUMBER, date CLOB, overall_rating NUMBER, potential NUMBER, preferred_foot CLOB, attacking_work_rate CLOB, defensive_work_rate CLOB, crossing NUMBER, finishing NUMBER, heading_accuracy NUMBER, short_passing NUMBER, volleys NUMBER, dribbling NUMBER, curve NUMBER, free_kick_accuracy NUMBER, long_passing NUMBER, ball_control NUMBER, acceleration NUMBER, sprint_speed NUMBER, agility NUMBER, reactions NUMBER, balance NUMBER, shot_power NUMBER, jumping NUMBER, stamina NUMBER, strength NUMBER, long_shots NUMBER, aggression NUMBER, interceptions NUMBER, positioning NUMBER, vision NUMBER, penalties NUMBER, marking NUMBER, standing_tackle NUMBER, sliding_tackle NUMBER, gk_diving NUMBER, gk_handling NUMBER, gk_kicking NUMBER, gk_positioning NUMBER, gk_reflexes NUMBER)

List all of the player ids with a height of at least 180cm and an overall rating higher than 85.
SELECT player_api_id FROM player WHERE height >= 180 INTERSECT SELECT player_api_id FROM player_attributes WHERE overall_rating > 85
SELECT "player_api_id" FROM "player" WHERE "height" >= 180 INTERSECT SELECT "player_api_id" FROM "player_attributes" WHERE "overall_rating" > 85