Table: game_stats_1988
Columns: date
time
opponent
rank
result
attendance

Question: What was the result when the opponent was at 2 usc?
SQL: SELECT "result" FROM game_stats_1988 WHERE "opponent" = 'at 2 usc'

Question: What was the result on 10/08/1988?
SQL: SELECT "result" FROM game_stats_1988 WHERE "date" = '10/08/1988'

Question: What was the rank# of the opponent when the result of the game was w42-14?
SQL: SELECT "rank" FROM game_stats_1988 WHERE "result" = 'w42-14'

Question: What was the result of the game that had 56,500 in attendance?
SQL: SELECT "result" FROM game_stats_1988 WHERE "attendance" = '56,500'

Question: What was the rank# of the opponent when there was 93,829 in attendance?
SQL: SELECT "rank" FROM game_stats_1988 WHERE "attendance" = '93,829'

Question: On what date was the game played where the opponent was Stanford, ranked #5?
SQL: SELECT "date" FROM game_stats_1988 WHERE "rank" = '5' AND "opponent" = 'stanford'