Which 1997's 1992 was 1r when 1994 was a?
CREATE TABLE table_name_77 (Id VARCHAR)
SELECT 1997 FROM table_name_77 WHERE 1992 = "1r" AND 1994 = "a"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (Id VARCHAR) Question: Which 1997's 1992 was 1r when 1994 was a? [/INST] SELECT 1997 FROM table_name_77 WHERE 1992 = "1r" AND 1994 = "a" </s>