CREATE TABLE table_74823 ("Rank" FLOAT, "Name" CLOB, "Location" CLOB, "Height Metres / feet" CLOB, "Floors" CLOB)

Which Height Metres / feet has a Rank of 8, and Floors of 3x17?
SELECT "Height Metres / feet" FROM table_74823 WHERE "Rank" = '8' AND "Floors" = '3x17'
SELECT "Height Metres / feet" FROM "table_74823" WHERE "Floors" = '3x17' AND "Rank" = '8'