Table: maccabiah_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What was the bronze medal count of the team that finished with 47 total medals?
SQL: SELECT AVG("bronze") FROM maccabiah_medals WHERE "total" = 47

Question: What is the silver medal count of the team that finished with 8 bronze medals?
SQL: SELECT SUM("silver") FROM maccabiah_medals WHERE "bronze" = 8