Table: figure_skating_championships_1980
Columns: rank
nation
gold
silver
bronze
total

Question: what is the highest rank with a total less than 1?
SQL: SELECT MAX("rank") FROM figure_skating_championships_1980 WHERE "total" < 1

Question: what is the average bronze when gold is 1, the nation is hungary and the rank is less than 3?
SQL: SELECT AVG("bronze") FROM figure_skating_championships_1980 WHERE "gold" = 1 AND "nation" = 'hungary' AND "rank" < 3

Question: How many times was the total more than 1, the nation was east germany and silver was more than 1?
SQL: SELECT COUNT("bronze") FROM figure_skating_championships_1980 WHERE "total" > 1 AND "nation" = 'east germany' AND "silver" > 1

Question: what is the average rank when the nation is east germany and silver is more than 1?
SQL: SELECT AVG("rank") FROM figure_skating_championships_1980 WHERE "nation" = 'east germany' AND "silver" > 1