CREATE TABLE table_203_350 (id NUMBER, "team #1" CLOB, "agg." CLOB, "team #2" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

how many times was the score 1-0 in the 1st leg ?
SELECT COUNT(*) FROM table_203_350 WHERE "1st leg" = '1-0'
SELECT COUNT(*) FROM "table_203_350" WHERE "1st leg" = '1-0'