CREATE TABLE table_name_41 (avg_g VARCHAR, gain VARCHAR, loss VARCHAR, name VARCHAR)

How much Avg/G has a Loss larger than 117, and a Name of opponents, and a Gain smaller than 2444?
SELECT COUNT(avg_g) FROM table_name_41 WHERE loss > 117 AND name = "opponents" AND gain < 2444
SELECT COUNT("avg_g") FROM "table_name_41" WHERE "gain" < 2444 AND "loss" > 117 AND "name" = "opponents"