What's the total long for an avg/g over 0.2, fewer than 2 loss, and a gain less than 8?
CREATE TABLE table_12214 (
    "Name" text,
    "GP-GS" text,
    "Gain" real,
    "Loss" real,
    "Long" real,
    "Avg/G" real
)
SELECT COUNT("Long") FROM table_12214 WHERE "Avg/G" > '0.2' AND "Loss" < '2' AND "Gain" < '8'
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: What's the total long for an avg/g over 0.2, fewer than 2 loss, and a gain less than 8? ### Input: CREATE TABLE table_12214 (
    "Name" text,
    "GP-GS" text,
    "Gain" real,
    "Loss" real,
    "Long" real,
    "Avg/G" real
) ### Response: SELECT COUNT("Long") FROM table_12214 WHERE "Avg/G" > '0.2' AND "Loss" < '2' AND "Gain" < '8'