Table: game_stats_10
Columns: date
venue
score
result
competition

Question: What competition has June 19, 2004 as the date?
SQL: SELECT "competition" FROM game_stats_10 WHERE "date" = 'june 19, 2004'

Question: What result has January 21, 2002 as the date?
SQL: SELECT "result" FROM game_stats_10 WHERE "date" = 'january 21, 2002'

Question: What date has alamodome, san antonio, united states as the venue?
SQL: SELECT "date" FROM game_stats_10 WHERE "venue" = 'alamodome, san antonio, united states'

Question: What date has 2006 fifa world cup qualification as the competition, and alamodome, san antonio, united States as the venue?
SQL: SELECT "date" FROM game_stats_10 WHERE "competition" = '2006 fifa world cup qualification' AND "venue" = 'alamodome, san antonio, united states'