What rank has a status of proposed, with 80 floors for Celestia Spaces 4?
CREATE TABLE "approved_proposed" (
  "rank" real,
  "name" text,
  "status" text,
  "city" text,
  "floors" real
);
SELECT AVG("rank") FROM "approved_proposed" WHERE "status"='proposed' AND "floors"=80 AND "name"='celestia spaces 4';