Table: staunton_games
Columns: date
opponent
result
odds
location
score

Question: What is the score where Saint-Amant lost the match?
SQL: SELECT "score" FROM staunton_games WHERE "opponent" = 'saint-amant' AND "result" = 'lost'

Question: Where was the match located when the odds were p + 1 and the score was 1/3?
SQL: SELECT "location" FROM staunton_games WHERE "odds" = 'p + 1' AND "score" = '1/3'

Question: What was the score for an n/a location with the odds of p + 1?
SQL: SELECT "result" FROM staunton_games WHERE "location" = 'n/a' AND "odds" = 'p + 1'

Question: What was the score for a game with the odds of p + 2 after 1847?
SQL: SELECT "score" FROM staunton_games WHERE "odds" = 'p + 2' AND "date" > 1847

Question: What was the date of a game that had the odds of q rook?
SQL: SELECT AVG("date") FROM staunton_games WHERE "odds" = 'q rook'