Table: game_results_2008
Columns: date
opponent
location
score
loss
record

Question: What is the Score for the game with a record of 38-18?
SQL: SELECT "score" FROM game_results_2008 WHERE "record" = '38-18'

Question: What team was the opponent when the score was 8-2?
SQL: SELECT "opponent" FROM game_results_2008 WHERE "score" = '8-2'

Question: What is the Location when the opponent shows vs. ole miss, and a Loss of mckean (4-1)?
SQL: SELECT "location" FROM game_results_2008 WHERE "opponent" = 'vs. ole miss' AND "loss" = 'mckean (4-1)'

Question: What is the name of the Opponent when there is a Record of 39-19?
SQL: SELECT "opponent" FROM game_results_2008 WHERE "record" = '39-19'

Question: What is the Record on may 24, with a Loss of hayes (2-1)?
SQL: SELECT "record" FROM game_results_2008 WHERE "date" = 'may 24' AND "loss" = 'hayes (2-1)'

Question: What is the Location when the Opponent shows vs. #23 south carolina?
SQL: SELECT "location" FROM game_results_2008 WHERE "opponent" = 'vs. #23 south carolina'