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

who had the most promotions , nuova sebastiani rieti or new basket brindisi ?
SELECT "team" FROM table_204_506 WHERE "team" IN ('nuova sebastiani rieti', 'new basket brindisi') ORDER BY "promotions" DESC LIMIT 1
SELECT "team" FROM "table_204_506" WHERE "team" IN ('nuova sebastiani rieti', 'new basket brindisi') ORDER BY "promotions" DESC FETCH FIRST 1 ROWS ONLY