CREATE TABLE table_204_475 (id NUMBER, "home team" CLOB, "score" CLOB, "away team" CLOB, "date" CLOB, "agg" CLOB)

how many times did the home team have a score of only one against the away team ?
SELECT COUNT(*) FROM table_204_475 WHERE "score" = 1
SELECT COUNT(*) FROM "table_204_475" WHERE "score" = 1