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

Question: What is the average number of rounds when fighting against Clay Guida?
SQL: SELECT AVG("round") FROM fighter_stats WHERE "opponent" = 'clay guida'

Question: Where was the fight against Gray Maynard?
SQL: SELECT "location" FROM fighter_stats WHERE "opponent" = 'gray maynard'

Question: What was the result of the 4:27 fight?
SQL: SELECT "res" FROM fighter_stats WHERE "time" = '4:27'

Question: What was the record at WEC 24?
SQL: SELECT "record" FROM fighter_stats WHERE "event" = 'wec 24'

Question: What was the result when there were less than 3 rounds against Gil Rael?
SQL: SELECT "res" FROM fighter_stats WHERE "round" < 3 AND "opponent" = 'gil rael'