Table: election_2008_tn
Columns: county
obama
obama_2
mccain
mccain_2

Question: In what county did McCain get 57.8%?
SQL: SELECT "county" FROM election_2008_tn WHERE "mccain_2" = '57.8%'

Question: How many figures are given for McCain's % in Davidson county?
SQL: SELECT COUNT("mccain_2") FROM election_2008_tn WHERE "county" = 'DAVIDSON'

Question: What percentage did Obama get in Rutherford county?
SQL: SELECT "obama_2" FROM election_2008_tn WHERE "county" = 'RUTHERFORD'

Question: What percentage did McCain get in Hamilton county?
SQL: SELECT "mccain_2" FROM election_2008_tn WHERE "county" = 'HAMILTON'

Question: What percentage did Obama get when McCain got 52.8%?
SQL: SELECT "obama_2" FROM election_2008_tn WHERE "mccain_2" = '52.8%'

Question: How many votes did Obama get in Lake County?
SQL: SELECT MIN("obama") FROM election_2008_tn WHERE "county" = 'LAKE'