What are the distinct years in which the competitions type is not "Tournament"?
CREATE TABLE competition (YEAR VARCHAR, Competition_type VARCHAR)
[SQL] SELECT DISTINCT YEAR FROM competition WHERE Competition_type <> "Tournament" [/SQL]