CREATE TABLE table_203_4 (id DECIMAL, "medal" TEXT, "name" TEXT, "sport" TEXT, "event" TEXT, "date" TEXT)

how many earned their gold medals in rowing ?
SELECT COUNT("name") FROM table_203_4 WHERE "medal" = 'gold' AND "sport" = 'rowing'
SELECT COUNT("name") FROM "table_203_4" WHERE "medal" = 'gold' AND "sport" = 'rowing'