CREATE TABLE table_204_747 (id NUMBER, "season" CLOB, "skip" CLOB, "third" CLOB, "second" CLOB, "lead" CLOB, "events" CLOB)

what is the total number of seasons that scott pfeifer was in second ?
SELECT COUNT("season") FROM table_204_747 WHERE "second" = 'scott pfeifer'
SELECT COUNT("season") FROM "table_204_747" WHERE "second" = 'scott pfeifer'