Table: fighter_results_28
Columns: result
tuf_competitor
opponent
method
event
date

Question: what is the method when the result is loss on january 19, 2008?
SQL: SELECT "method" FROM fighter_results_28 WHERE "result" = 'loss' AND "date" = 'january 19, 2008'

Question: when is the opponent lyoto machida?
SQL: SELECT "date" FROM fighter_results_28 WHERE "opponent" = 'lyoto machida'

Question: who is the opponent when the method is tko (punches) at 4:26 of round 1?
SQL: SELECT "opponent" FROM fighter_results_28 WHERE "method" = 'tko (punches) at 4:26 of round 1'

Question: who is the tuf competitor when the method id decision (unanimous)?
SQL: SELECT "tuf_competitor" FROM fighter_results_28 WHERE "method" = 'decision (unanimous)'

Question: who is the opponent when the method is submission (rear naked choke) at 4:02 of round 2?
SQL: SELECT "opponent" FROM fighter_results_28 WHERE "method" = 'submission (rear naked choke) at 4:02 of round 2'