CREATE TABLE table_204_506 (id NUMBER, "seasons" NUMBER, "team" CLOB, "ch.wins" NUMBER, "promotions" NUMBER, "relegations" NUMBER)

other than scafati basket , who appeared in 9 seasons ?
SELECT "team" FROM table_204_506 WHERE "team" <> 'scafati basket' AND "seasons" = 9
SELECT "team" FROM "table_204_506" WHERE "seasons" = 9 AND "team" <> 'scafati basket'