Table: mma_fights_23
Columns: res
record
opponent
method
event
location

Question: What is the record when Danilo Pereira was the opponent?
SQL: SELECT "record" FROM mma_fights_23 WHERE "opponent" = 'danilo pereira'

Question: Which event had Edson Claas Vieira as an opponent?
SQL: SELECT "event" FROM mma_fights_23 WHERE "opponent" = 'edson claas vieira'

Question: Which method was used when Rafael Cavalcante was the opponent?
SQL: SELECT "method" FROM mma_fights_23 WHERE "opponent" = 'rafael cavalcante'

Question: Which method was used when Alessio Sakara was the opponent?
SQL: SELECT "method" FROM mma_fights_23 WHERE "opponent" = 'alessio sakara'

Question: Who is the opponent when the record is 3-8?
SQL: SELECT "opponent" FROM mma_fights_23 WHERE "record" = '3-8'