CREATE TABLE table_name_27 (gold INT, total VARCHAR, rank VARCHAR, silver VARCHAR)

How many gold medals for a nation with rank less than 5, more than 0 silvers and a total of 2 medals?
SELECT AVG(gold) FROM table_name_27 WHERE rank < 5 AND silver > 0 AND total = 2
SELECT AVG("gold") FROM "table_name_27" WHERE "rank" < 5 AND "silver" > 0 AND "total" = 2