How many rounds were fought with opponent Kevin Roddy?
CREATE TABLE table_name_54 (
    round VARCHAR,
    opponent VARCHAR
)
SELECT COUNT(round) FROM table_name_54 WHERE opponent = "kevin roddy"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many rounds were fought with opponent Kevin Roddy? ### Input: CREATE TABLE table_name_54 (
    round VARCHAR,
    opponent VARCHAR
) ### Response: SELECT COUNT(round) FROM table_name_54 WHERE opponent = "kevin roddy"