CREATE TABLE table_name_47 (competition VARCHAR2, year VARCHAR2, notes VARCHAR2)

What competition was held earlier than 2007 and has 7434 in the notes field?
SELECT competition FROM table_name_47 WHERE year < 2007 AND notes = "7434"
SELECT "competition" FROM "table_name_47" WHERE "7434" = "notes" AND "year" < 2007