CREATE TABLE table_name_82 (gold_medals NUMBER, total_medals VARCHAR2, bronze_medals VARCHAR2, silver_medals VARCHAR2)

Name the average gold medals when the bronze medals was less than 1, silver medals being 0 and total medals more than 1
SELECT AVG(gold_medals) FROM table_name_82 WHERE bronze_medals < 1 AND silver_medals = 0 AND total_medals > 1
SELECT AVG("gold_medals") FROM "table_name_82" WHERE "bronze_medals" < 1 AND "silver_medals" = 0 AND "total_medals" > 1