user: ### NOW ANSWER:
Question: How many rounds were fought with opponent kevin roddy?
Columns: ['Res.', 'Record', 'Opponent', 'Method', 'Event', 'Round', 'Time', 'Location']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['NC', '22–4 (1)', 'Pat Healy', 'NC (overturned)', 'UFC 159', 3.0, '4:02', 'Newark, New Jersey , United States']
SQL:

assistant: SELECT COUNT("Round") FROM "Table" WHERE "Opponent" = 'kevin roddy';