Task: Text to Code
Input (English): Step 1: find the number of rows of each value of Location in school table.
Step 2: find Location in school table whose corresponding value in step 1 is greater than 1
Output (English): SELECT Location FROM school GROUP BY Location HAVING Count ( * ) > 1