CREATE TABLE table_name_47 (team VARCHAR2, total VARCHAR2, tournament VARCHAR2, regular_season VARCHAR2)

What team has over 1 tournament title, 0 in the regular season, and 2 total?
SELECT team FROM table_name_47 WHERE tournament > 1 AND regular_season = "0" AND total = 2
SELECT "team" FROM "table_name_47" WHERE "0" = "regular_season" AND "total" = 2 AND "tournament" > 1