What rank has a status of proposed, with 80 floors for Celestia Spaces 4?
CREATE TABLE table_name_79 (
    rank INTEGER,
    name VARCHAR,
    status VARCHAR,
    floors VARCHAR
)
SELECT AVG(rank) FROM table_name_79 WHERE status = "proposed" AND floors = 80 AND name = "celestia spaces 4"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What rank has a status of proposed, with 80 floors for Celestia Spaces 4? ### Input: CREATE TABLE table_name_79 (
    rank INTEGER,
    name VARCHAR,
    status VARCHAR,
    floors VARCHAR
) ### Response: SELECT AVG(rank) FROM table_name_79 WHERE status = "proposed" AND floors = 80 AND name = "celestia spaces 4"