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