Task: Text to Code
Input (English): Step 1: find the average duration in trip table whose subscription_type equals 94103.
Step 2: find the id of trip table whose duration greater than the results of step 1
Output (English): SELECT id FROM trip WHERE duration > ( SELECT Avg ( duration ) FROM trip WHERE subscription_type = 94103 )