Task: Text to Code
Input (English): Step 1: find the number of rows of each value of state in College table.
Step 2: find state in College table whose corresponding value in step 1 is equals 1
Output (English): SELECT state FROM College GROUP BY state HAVING Count ( * ) = 1