Table: commonwealth_2006_medals
Columns: rank
gold
silver
bronze
total

Question: What is the most Bronze medals won among the participants that won less than 22 medals overall and less than 5 silver medals?
SQL: SELECT MAX("bronze") FROM commonwealth_2006_medals WHERE "total" < 22 AND "silver" < 5

Question: How many silver medals were won by the participant(s) that had more than 12 gold medals and 11 bronze medals?
SQL: SELECT "silver" FROM commonwealth_2006_medals WHERE "gold" > 12 AND "bronze" = 11

Question: What is the average number of gold medals won among participants that won less than 13 silver, less than 8 bronze, and more than 18 medals overall?
SQL: SELECT AVG("gold") FROM commonwealth_2006_medals WHERE "silver" < 13 AND "total" > 18 AND "bronze" < 8