CREATE TABLE table_203_397 (id NUMBER, "series" CLOB, "launch date" CLOB, "finale date" CLOB, "days" NUMBER, "housemates" NUMBER, "winner" CLOB, "main presenter" CLOB, "grand prize" CLOB, "liveshow\ audience\ millions" NUMBER)

how many seasons lasted more than 100 days ?
SELECT COUNT("series") FROM table_203_397 WHERE "days" > 100
SELECT COUNT("series") FROM "table_203_397" WHERE "days" > 100