Table: boxer_match
Columns: date
result
opponent
method
round

Question: Which method resulting in a win against Ed Mahone?
SQL: SELECT "method" FROM boxer_match WHERE "result" = 'win' AND "opponent" = 'ed mahone'

Question: When did  the technical knockout against Fatu Tuimanono happen?
SQL: SELECT "date" FROM boxer_match WHERE "method" = 'technical knockout' AND "opponent" = 'fatu tuimanono'

Question: When did the opponent knockout Barry Prior in more than 2 rounds?
SQL: SELECT "date" FROM boxer_match WHERE "method" = 'knockout' AND "round" > 2 AND "opponent" = 'barry prior'

Question: What resulted after 4 rounds with Ed Mahone?
SQL: SELECT "result" FROM boxer_match WHERE "round" > 4 AND "opponent" = 'ed mahone'