Task: Text to Code
Input (English): Step 1: find the id of station table for which long greater than 37.4.
Step 2: For each row in station table, find the corresponding rows in status table.
Step 3: find station_id of the results of step 2 whose long less than 7.
Step 4: show the rows that are in both the results of step 1 and the results of step 3
Output (English): SELECT T1.id FROM station AS T1 WHERE T1.long > 37.4 INTERSECT SELECT T2.station_id FROM station AS T1 JOIN status AS T2 ON T1.id = T2.station_id WHERE T1.long < 7