Table schema:
CREATE TABLE table_name_30 (bronze INTEGER, silver VARCHAR, total VARCHAR, gold VARCHAR)

Question: Who has a total of the Bronze less than 4, gold more than 0, and no silver?
SQL: SELECT SUM(bronze) FROM table_name_30 WHERE total < 4 AND gold > 0 AND silver = 0