Table: dwts_scores
Columns: week
dance_song
horwood
goodman
dixon
tonioli
total
result

Question: What dance had a score total of 31?
SQL: SELECT "dance_song" FROM dwts_scores WHERE "total" = '31'

Question: What was the result for the dance that tonioli's scored an 8 and horwood scored a 6?
SQL: SELECT "result" FROM dwts_scores WHERE "tonioli" = '8' AND "horwood" = '6'

Question: How many times did tonioli score a 9 when horwood scored a 6?
SQL: SELECT COUNT("total") FROM dwts_scores WHERE "tonioli" = '9' AND "horwood" = '6'

Question: On week 11 when Dixon scored an 8, what was tonioli's score?
SQL: SELECT "tonioli" FROM dwts_scores WHERE "week" = 11 AND "dixon" = '8'