Table: capitals_game_stats_3
Columns: game
date
opponent
score
location
attendance
record
points

Question: List the results for all games which involved the detroit red wings.
SQL: SELECT "score" FROM capitals_game_stats_3 WHERE "opponent" = 'Detroit Red Wings'

Question: Calculate the highest points where the win,loss, tie ratio is  28-12-6
SQL: SELECT MAX("points") FROM capitals_game_stats_3 WHERE "record" = '28-12-6'

Question: what are the previous performance details for games involving the montreal canadiens?
SQL: SELECT "record" FROM capitals_game_stats_3 WHERE "opponent" = 'Montreal Canadiens'