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