How many INTs were there with an average less than 8, 0 long, and the player is Mike Douglass?
CREATE TABLE table_6298 (
    "Player" text,
    "Sacks" real,
    "INT'S" real,
    "Yards" real,
    "Average" real,
    "Long" text
)
SELECT COUNT("INT'S") FROM table_6298 WHERE "Average" < '8' AND "Long" = '0' AND "Player" = 'mike douglass'
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 INTs were there with an average less than 8, 0 long, and the player is Mike Douglass? ### Input: CREATE TABLE table_6298 (
    "Player" text,
    "Sacks" real,
    "INT'S" real,
    "Yards" real,
    "Average" real,
    "Long" text
) ### Response: SELECT COUNT("INT'S") FROM table_6298 WHERE "Average" < '8' AND "Long" = '0' AND "Player" = 'mike douglass'