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

Question: Who's the opponent with a time of 3:24?
SQL: SELECT "opponent" FROM fighter_results_15 WHERE "time" = '3:24'

Question: What's the record that had an opponent of Krzysztof Soszynski and a time of 4:00?
SQL: SELECT "record" FROM fighter_results_15 WHERE "time" = '4:00' AND "opponent" = 'krzysztof soszynski'

Question: What's the time of IFL: Championship Final?
SQL: SELECT "time" FROM fighter_results_15 WHERE "event" = 'ifl: championship final'