Table: island_games_2005
Columns: rank
nation
gold
silver
bronze
total

Question: Name the least rank with bronze of 2, gold more than 0 and nation of ynys môn/anglesey with total more than 8
SQL: SELECT MIN("rank") FROM island_games_2005 WHERE "bronze" = 2 AND "gold" > 0 AND "nation" = 'ynys môn/anglesey' AND "total" > 8

Question: Name the least total with rank less than 7, gold more than 16 and bronze less than 29
SQL: SELECT MIN("total") FROM island_games_2005 WHERE "rank" < 7 AND "gold" > 16 AND "bronze" < 29

Question: Name the total number of total with silver of 6, bronze more than 5 and gold less than 4
SQL: SELECT COUNT("total") FROM island_games_2005 WHERE "silver" = 6 AND "bronze" > 5 AND "gold" < 4