CREATE TABLE table_name_15 (Id VARCHAR2)

Which 2006 Tournament has a 2004, and a 2002 of not tier i?
SELECT 2006 FROM table_name_15 WHERE 2004 = "a" AND 2002 = "not tier i"
SELECT 2006 FROM "table_name_15" WHERE "a" = 2004 AND "not tier i" = 2002