Table: mma_fight_results_9
Columns: res
record
opponent
method
round
time
location

Question: What's the method for a record of 4-2 and round smaller than 3?
SQL: SELECT "method" FROM mma_fight_results_9 WHERE "round" < 3 AND "record" = '4-2'

Question: Where's the location for the opponent James Zikic and 3 rounds?
SQL: SELECT "location" FROM mma_fight_results_9 WHERE "round" = 3 AND "opponent" = 'james zikic'