CREATE TABLE table_203_656 (id NUMBER, "date" CLOB, "opponent" CLOB, "venue" CLOB, "result" CLOB, "scorers" CLOB, "report" CLOB)

how many matches were lost ?
SELECT COUNT(*) FROM table_203_656 WHERE "result" = 'lost'
SELECT COUNT(*) FROM "table_203_656" WHERE "result" = 'lost'