user: ### NOW ANSWER:
Question: How many INTs were there with an average less than 8, 0 long, and the player is mike douglass?
Columns: ['Player', 'Sacks', "INT'S", 'Yards', 'Average', 'Long']
Types: ['text', 'real', 'real', 'real', 'real', 'text']
Sample row: ['John Anderson', 3.5, 3.0, 24.0, 8.0, '22']
SQL:

assistant: SELECT COUNT("INT'S") FROM "Table" WHERE "Average" < 8.0 AND "Long" = '0' AND "Player" = 'mike douglass';