Table: allsvenskan_standings
Columns: rank
club
gold
big_silver
small_silver
bronze
points

Question: For clubs that have 0 gold and less than 5 points, what is the average amount of bronze medals?
SQL: SELECT AVG("bronze") FROM allsvenskan_standings WHERE "points" < 5 AND "gold" < 0

Question: Club aik had over 9 small silver medals and more than 8 bronze medals, how many total points did they have?
SQL: SELECT AVG("points") FROM allsvenskan_standings WHERE "small_silver" > 9 AND "club" = 'aik' AND "bronze" > 8

Question: How many points did landskrona bois get when they were ranked below 18?
SQL: SELECT COUNT("points") FROM allsvenskan_standings WHERE "club" = 'landskrona bois' AND "rank" < 18