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

Question: What is the round of the match with Emanuel Newton as the opponent?
SQL: SELECT "round" FROM roger_hollett_fight_record WHERE "opponent" = 'emanuel newton'

Question: What is the location of the match with Aron Lofton as the opponent?
SQL: SELECT "location" FROM roger_hollett_fight_record WHERE "opponent" = 'aron lofton'

Question: What is the location of the match with an event of ecc 8: comeback?
SQL: SELECT "location" FROM roger_hollett_fight_record WHERE "event" = 'ecc 8: comeback'

Question: Who is the opponent of the match with a win result and a time of 3:02?
SQL: SELECT "opponent" FROM roger_hollett_fight_record WHERE "res" = 'win' AND "time" = '3:02'

Question: What is the method of the match with 1 round and a time of 1:58?
SQL: SELECT "method" FROM roger_hollett_fight_record WHERE "round" = 1 AND "time" = '1:58'