What is the tournament that had a result of A in 1954 and NH in 1942?
CREATE TABLE table_name_30 (tournament VARCHAR)
SELECT tournament FROM table_name_30 WHERE 1954 = "a" AND 1942 = "nh"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (tournament VARCHAR) Question: What is the tournament that had a result of A in 1954 and NH in 1942? [/INST] SELECT tournament FROM table_name_30 WHERE 1954 = "a" AND 1942 = "nh" </s>