Task: Text to Code
Input (English): Step 1: find the average MIN_SALARY of each value of JOB_ID in jobs table.
Step 2: find JOB_ID in jobs table whose corresponding value in step 1 is greater than 8000
Output (English): SELECT JOB_ID FROM jobs GROUP BY JOB_ID HAVING Avg ( MIN_SALARY ) > 8000