CREATE TABLE table_204_11 (id NUMBER, "year" NUMBER, "fbs opponent" CLOB, "result" CLOB, "opponent's conference" CLOB, "opponent's head coach" CLOB, "charleston southern's head coach" CLOB)

how long was david dowd head coach ?
SELECT COUNT("year") FROM table_204_11 WHERE "charleston southern's head coach" = 'david dowd'
SELECT COUNT("year") FROM "table_204_11" WHERE "charleston southern's head coach" = 'david dowd'