Table: aldridge_goals
Columns: goal
date
venue
score
result
competition

Question: What competition was at the Daugava Stadium, Riga, Latvia?
SQL: SELECT "competition" FROM aldridge_goals WHERE "venue" = 'daugava stadium, riga, latvia'

Question: How many total goals were made at the game on 15 November 1989?
SQL: SELECT COUNT("goal") FROM aldridge_goals WHERE "date" = '15 november 1989'