CREATE TABLE Apartment_Buildings (building_id VARCHAR, building_short_name VARCHAR)
CREATE TABLE Apartments (room_count INT, building_id VARCHAR)

Show the total number of rooms of the apartments in the building with short name 'Columbus Square'.
SELECT SUM(T2.room_count) FROM Apartment_Buildings AS T1 JOIN Apartments AS T2 ON T1.building_id = T2.building_id WHERE T1.building_short_name = "Columbus Square"
SELECT SUM("T2"."room_count") FROM "Apartment_Buildings" AS "T1" JOIN "Apartments" AS "T2" ON "T1"."building_id" = "T2"."building_id" WHERE "Columbus Square" = "T1"."building_short_name"