Table: vampiro_match
Columns: wager
winner
loser
location
date

Question: What is the date of the match where vampiro was the winner in Mexico City?
SQL: SELECT "date" FROM vampiro_match WHERE "location" = 'mexico city' AND "winner" = 'vampiro'

Question: What is the wager on August 23, 1992 where vampiro was the winner?
SQL: SELECT "wager" FROM vampiro_match WHERE "winner" = 'vampiro' AND "date" = 'august 23, 1992'

Question: What is the location where shocker was the winner?
SQL: SELECT "location" FROM vampiro_match WHERE "winner" = 'shocker'

Question: What is the location where aaron grundy was the loser?
SQL: SELECT "location" FROM vampiro_match WHERE "loser" = 'aaron grundy'