CREATE TABLE Player (player_api_id VARCHAR, preferred_foot VARCHAR, height VARCHAR)
CREATE TABLE Player_Attributes (player_api_id VARCHAR, preferred_foot VARCHAR, height VARCHAR)

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"