CREATE TABLE table_name_54 (round VARCHAR, opponent VARCHAR)

How many rounds were fought with opponent Kevin Roddy?
SELECT COUNT(round) FROM table_name_54 WHERE opponent = "kevin roddy"
SELECT COUNT("round") FROM "table_name_54" WHERE "kevin roddy" = "opponent"