Task: Text to Code
Input (English): List all of the ids for left-footed players with a height between 180cm and 190cm.
Output (English): SELECT player_api_id FROM Player WHERE height  >=  180 AND height  <=  190 INTERSECT SELECT player_api_id FROM Player_Attributes WHERE preferred_foot  =  "left"