Table: pioneers_2007_season
Columns: week
date
opponent
result
record
game_site

Question: What is the number week with a result of w 40–62?
SQL: SELECT SUM("week") FROM pioneers_2007_season WHERE "result" = 'w 40–62'

Question: What was the game site week 15?
SQL: SELECT "game_site" FROM pioneers_2007_season WHERE "week" = 15

Question: What is the record when the result was w 52–43?
SQL: SELECT "record" FROM pioneers_2007_season WHERE "result" = 'w 52–43'

Question: What is the highest week when the game site was Verizon Wireless Arena, and the result was w 59–42?
SQL: SELECT MAX("week") FROM pioneers_2007_season WHERE "game_site" = 'verizon wireless arena' AND "result" = 'w 59–42'

Question: What is the opponent on May 25, 2007?
SQL: SELECT "opponent" FROM pioneers_2007_season WHERE "date" = 'may 25, 2007'

Question: What team was the opponent with a record of 5–0?
SQL: SELECT "opponent" FROM pioneers_2007_season WHERE "record" = '5–0'