I need the surpassed for years before 1925 and period of 6 years
CREATE TABLE table_10583 (
    "Name" text,
    "City" text,
    "Height feet/m" text,
    "Year" real,
    "Period" text,
    "Surpassed by" text
)
SELECT "Surpassed by" FROM table_10583 WHERE "Year" < '1925' AND "Period" = '6 years'
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: I need the surpassed for years before 1925 and period of 6 years ### Input: CREATE TABLE table_10583 (
    "Name" text,
    "City" text,
    "Height feet/m" text,
    "Year" real,
    "Period" text,
    "Surpassed by" text
) ### Response: SELECT "Surpassed by" FROM table_10583 WHERE "Year" < '1925' AND "Period" = '6 years'