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"