Table: judoscores_2008
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average Bronze, when Nation is "North Korea", and when Total is greater than 5?
SQL: SELECT AVG("bronze") FROM judoscores_2008 WHERE "nation" = 'north korea' AND "total" > 5

Question: What is the lowest Bronze, when Total is greater than 10, when Silver is greater than 0, and when Rank is "Total"?
SQL: SELECT MIN("bronze") FROM judoscores_2008 WHERE "total" > 10 AND "silver" > 0 AND "rank" = 'total'

Question: What is Rank, when Silver is less than 6, when Bronze is greater than 4, and when Total is 10?
SQL: SELECT "rank" FROM judoscores_2008 WHERE "silver" < 6 AND "bronze" > 4 AND "total" = 10

Question: What is Gold, when Rank is 7?
SQL: SELECT "gold" FROM judoscores_2008 WHERE "rank" = '7'