Table: shandel_samuel_match_stats
Columns: date
venue
score
result
competition

Question: What is the result when the competition was the 2006 fifa world cup qualifier, and a Venue of warner park sporting complex, bassaterre?
SQL: SELECT "result" FROM shandel_samuel_match_stats WHERE "competition" = '2006 fifa world cup qualifier' AND "venue" = 'warner park sporting complex, bassaterre'

Question: What is the name of the venue when the competition was friendly, with a Result of 2–3?
SQL: SELECT "venue" FROM shandel_samuel_match_stats WHERE "competition" = 'friendly' AND "result" = '2–3'

Question: What is the name of the venue when the score was 5–0, and a Competition of 2007 caribbean cup qualifier?
SQL: SELECT "venue" FROM shandel_samuel_match_stats WHERE "score" = '5–0' AND "competition" = '2007 caribbean cup qualifier'