Task: Text to Code
Input (English): Step 1: For each row in departments table, find the corresponding rows in employees table.
Step 2: find the number of rows of each value of employees's DEPARTMENT_ID in the results of step 1.
Step 3: find DEPARTMENT_NAME in the results of step 1 whose corresponding value in step 2 is greater than 10
Output (English): SELECT T1.DEPARTMENT_NAME FROM departments AS T1 JOIN employees AS T2 ON T1.DEPARTMENT_ID = T2.DEPARTMENT_ID GROUP BY T2.DEPARTMENT_ID HAVING Count ( * ) > 10