Table: fighter_match_29
Columns: res
record
opponent
method
event
round
time
location

Question: Who was the opponent in the match that lasted 4:17?
SQL: SELECT "opponent" FROM fighter_match_29 WHERE "time" = '4:17'

Question: Where was the match that lasted less than 3 rounds and was won by submission (triangle choke)?
SQL: SELECT "location" FROM fighter_match_29 WHERE "round" < 3 AND "method" = 'submission (triangle choke)'

Question: Which event had Carlos Alexandre Pereira as opponent?
SQL: SELECT "event" FROM fighter_match_29 WHERE "opponent" = 'carlos alexandre pereira'

Question: Where was the match that resulted in a win in 4:16 held?
SQL: SELECT "location" FROM fighter_match_29 WHERE "res" = 'win' AND "time" = '4:16'