CREATE TABLE table_204_884 (id NUMBER, "medal" CLOB, "name" CLOB, "sport" CLOB, "event" CLOB, "date" CLOB)

how many total gold medals were won by weightlifting ?
SELECT COUNT(*) FROM table_204_884 WHERE "medal" = 'gold' AND "sport" = 'weightlifting'
SELECT COUNT(*) FROM "table_204_884" WHERE "medal" = 'gold' AND "sport" = 'weightlifting'