CREATE TABLE table_203_648 (id NUMBER, "date" CLOB, "opposition" CLOB, "result" CLOB, "score" CLOB, "brazil scorers" CLOB, "competition" CLOB)

total number of wins
SELECT COUNT(*) FROM table_203_648 WHERE "result" = 'w'
SELECT COUNT(*) FROM "table_203_648" WHERE "result" = 'w'