user: ### NOW ANSWER:
Question: The match that was held at Club Med Sandpiper has what method?
Columns: ['Date', 'Result', 'Opponent', 'Venue', 'Location', 'Method', 'Round', 'Time', 'Record']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['2009-02-28', 'Win', 'Troy Nelson', 'Shoreline Ball Room', 'Hilton Head, South Carolina, USA', 'Decision', 6.0, '3:00', '6-2-1']
SQL:

assistant: SELECT "Method" FROM "Table" WHERE "Venue" = 'Club Med Sandpiper';