Table: kansas_city_2006_season
Columns: week
date
opponent
home_away_game
result

Question: What is the result where the opponent is Columbus Destroyers?
SQL: SELECT "result" FROM kansas_city_2006_season WHERE "opponent" = 'columbus destroyers'

Question: What is the date of the away game in week 8?
SQL: SELECT "date" FROM kansas_city_2006_season WHERE "home_away_game" = 'away' AND "week" = 8