user: ### NOW ANSWER:
Question: Name the total number of offensive for Colin Doyle
Columns: ['Month', 'Week', 'Overall', 'Offensive', 'Defensive', 'Transition', 'Rookie']
Types: ['text', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: ['January', 1.0, 'Josh Sanderson', 'Josh Sanderson', "Pat O'Toole", 'Paul Rabil', 'Garrett Billings']
SQL:

assistant: SELECT COUNT("Offensive") FROM "Table" WHERE "Overall" = 'Colin Doyle';