I need the surpassed for years before 1925 and period of 6 years
CREATE TABLE table_name_57 (surpassed_by VARCHAR, year VARCHAR, period VARCHAR)
SELECT surpassed_by FROM table_name_57 WHERE year < 1925 AND period = "6 years"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_57 (surpassed_by VARCHAR, year VARCHAR, period VARCHAR) Question: I need the surpassed for years before 1925 and period of 6 years [/INST] SELECT surpassed_by FROM table_name_57 WHERE year < 1925 AND period = "6 years" </s>