Task: Text to Code
Input (English): Step 1: For each row in Apartment_Buildings table, find the corresponding rows in Apartments table.
Step 2: find the summation of room_count in the results of step 1 whose building_full_name equals Columbus Square and building_short_name equals Normandie Court
Output (English): SELECT Sum ( T2.room_count ) FROM Apartment_Buildings AS T1 JOIN Apartments AS T2 ON T1.building_id = T2.building_id WHERE T1.building_full_name = "Columbus Square" AND T1.building_short_name = "Normandie Court"