What competition was held earlier than 2007 and has 7434 in the notes field?
CREATE TABLE table_name_47 (competition VARCHAR, year VARCHAR, notes VARCHAR)
SELECT competition FROM table_name_47 WHERE year < 2007 AND notes = "7434"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (competition VARCHAR, year VARCHAR, notes VARCHAR) Question: What competition was held earlier than 2007 and has 7434 in the notes field? [/INST] SELECT competition FROM table_name_47 WHERE year < 2007 AND notes = "7434" </s>