Task: Text to Code
Input (English): Step 1: find the Player's player_api_id of Player table for which height greater than 180.
Step 2: For each row in Player table, find the corresponding rows in Player_Attributes table.
Step 3: find Player_Attributes's player_api_id of the results of step 2 whose height less than 85.
Step 4: show the rows that are in both the results of step 1 and the results of step 3
Output (English): SELECT T1.player_api_id FROM Player AS T1 WHERE T1.height > 180 INTERSECT SELECT T2.player_api_id FROM Player_Attributes AS T2 JOIN Player AS T1 ON T2.player_fifa_api_id = T1.player_fifa_api_id WHERE T1.height < 85