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