CREATE TABLE table_name_41 (teams VARCHAR2, season VARCHAR2)

Which teams were in the 2006-07 season?
SELECT teams FROM table_name_41 WHERE season = "2006-07"
SELECT "teams" FROM "table_name_41" WHERE "2006-07" = "season"