CREATE TABLE table_204_523 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "attendance" NUMBER, "record" CLOB)

how many times did a game result in a loss ?
SELECT COUNT(*) FROM table_204_523 WHERE "result" = 'loss'
SELECT COUNT(*) FROM "table_204_523" WHERE "result" = 'loss'