SELECT player_api_id FROM Player WHERE height  >=  180 AND height  <=  190 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE preferred_foot  =  "left"
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 > = value and height < = value intersect select player_api_id from player_attributes where preferred_foot = value
List all of the ids for left-footed players with a height between 180cm and 190cm .