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)
CREATE TABLE country (id NUMBER, name CLOB)
CREATE TABLE league (id NUMBER, country_id NUMBER, name 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 sqlite_sequence (name CLOB, seq 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 team (id NUMBER, team_api_id NUMBER, team_fifa_api_id NUMBER, team_long_name CLOB, team_short_name CLOB)

List all of the ids for left-footed players with a height between 180cm and 190cm.
SELECT player_api_id FROM player WHERE height >= 180 AND height <= 190 INTERSECT SELECT player_api_id FROM player_attributes WHERE preferred_foot = "left"
SELECT "player_api_id" FROM "player" WHERE "height" <= 190 AND "height" >= 180 INTERSECT SELECT "player_api_id" FROM "player_attributes" WHERE "left" = "preferred_foot"