Schema: CREATE TABLE table_name_82 (gold_medals INTEGER, total_medals VARCHAR, bronze_medals VARCHAR, silver_medals VARCHAR)
Question: Name the average gold medals when the bronze medals was less than 1, silver medals being 0 and total medals more than 1
SQL: SELECT AVG(gold_medals) FROM table_name_82 WHERE bronze_medals < 1 AND silver_medals = 0 AND total_medals > 1