Task: Text to Code
Input (English): find the number of rows in Apartment_Buildings table whose building_full_name equals Columbus Square and building_short_name equals Normandie Court
Output (English): SELECT Count ( * ) FROM Apartment_Buildings WHERE building_full_name = "Columbus Square" AND building_short_name = "Normandie Court"