Table: election_results_2004
Columns: county
kerry
kerry_2
bush
bush_2
others
others_2

Question: What is the value Others% when the value Others# is greater than 147 and the value Kerry% is 39.6%?
SQL: SELECT "others" FROM election_results_2004 WHERE "others_2" > 147 AND "kerry" = '39.6%'

Question: What is the average value of Bush# when the value for Others# is greater than 57, and the value for Bush% is 49.2%?
SQL: SELECT AVG("bush_2") FROM election_results_2004 WHERE "others_2" > 57 AND "bush" = '49.2%'