Task: Text to Code
Input (English): Step 1: For each row in station table, find the corresponding rows in trip table.
Step 2: find start_station_id, name, subscription_type of the results of step 1
Output (English): SELECT T2.start_station_id , T1.name , T2.subscription_type FROM station AS T1 JOIN trip AS T2