Table: dempsey_stats
Columns: date
venue
score
result
competition

Question: When was there a Result of 8–0 and a Score of 1–0?
SQL: SELECT "date" FROM dempsey_stats WHERE "result" = '8–0' AND "score" = '1–0'

Question: What was the result of Bridgeview, Illinois?
SQL: SELECT "result" FROM dempsey_stats WHERE "venue" = 'bridgeview, illinois'

Question: When did a Competition of friendly, and a Score of 2–1, and a Venue of philadelphia , pennsylvania occur?
SQL: SELECT "date" FROM dempsey_stats WHERE "competition" = 'friendly' AND "score" = '2–1' AND "venue" = 'philadelphia , pennsylvania'

Question: What was the score on June 28, 2009?
SQL: SELECT "score" FROM dempsey_stats WHERE "date" = 'june 28, 2009'