CREATE TABLE table_12214 ("Name" CLOB, "GP-GS" CLOB, "Gain" FLOAT, "Loss" FLOAT, "Long" FLOAT, "Avg/G" FLOAT)

What's the total long for an avg/g over 0.2, fewer than 2 loss, and a gain less than 8?
SELECT COUNT("Long") FROM table_12214 WHERE "Avg/G" > '0.2' AND "Loss" < '2' AND "Gain" < '8'
SELECT COUNT("Long") FROM "table_12214" WHERE "Avg/G" > '0.2' AND "Gain" < '8' AND "Loss" < '2'