CREATE TABLE table_10583 ("Name" CLOB, "City" CLOB, "Height feet/m" CLOB, "Year" FLOAT, "Period" CLOB, "Surpassed by" CLOB)

I need the surpassed for years before 1925 and period of 6 years
SELECT "Surpassed by" FROM table_10583 WHERE "Year" < '1925' AND "Period" = '6 years'
SELECT "Surpassed by" FROM "table_10583" WHERE "Period" = '6 years' AND "Year" < '1925'