CREATE TABLE Player_Attributes (player_api_id VARCHAR(255), preferred_foot VARCHAR(255), height VARCHAR(255)); CREATE TABLE Player (player_api_id VARCHAR(255), preferred_foot VARCHAR(255), height VARCHAR(255))
List all of the ids for left-footed players with a height between 180cm and 190cm.
    
SQL: SELECT player_api_id FROM Player WHERE height >= 180 AND height <= 190 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE preferred_foot = "left"