Table: fighter_match_23
Columns: date
result
opponent
venue
location
method
round
time
record

Question: The match that lasted 2:43 has what record?
SQL: SELECT "record" FROM fighter_match_23 WHERE "time" = '2:43'

Question: The match that was held at Club Med Sandpiper has what method?
SQL: SELECT "method" FROM fighter_match_23 WHERE "venue" = 'club med sandpiper'

Question: The match of at Michael's Eighth Avenue venue against Tim Coleman that went 3:00 has what record?
SQL: SELECT "record" FROM fighter_match_23 WHERE "time" = '3:00' AND "venue" = 'michael''s eighth avenue' AND "opponent" = 'tim coleman'

Question: What method did the match at Club Med Sandpiper have?
SQL: SELECT "method" FROM fighter_match_23 WHERE "venue" = 'club med sandpiper'