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

how many silver medals did india win in shooting ?
SELECT COUNT("name") FROM table_204_103 WHERE "sport" = 'shooting'
SELECT COUNT("name") FROM "table_204_103" WHERE "sport" = 'shooting'