CREATE TABLE table_204_117 (id NUMBER, "season" NUMBER, "level" CLOB, "division" CLOB, "section" CLOB, "position" CLOB, "movements" CLOB)

in total , how many times were they promoted ?
SELECT COUNT(*) FROM table_204_117 WHERE "movements" = 'promoted'
SELECT COUNT(*) FROM "table_204_117" WHERE "movements" = 'promoted'