CREATE TABLE table_name_27 (gain INT, long VARCHAR, avg_g VARCHAR)

How many gains have a long greater than 8, with avg/g of 124.9?
SELECT SUM(gain) FROM table_name_27 WHERE long > 8 AND avg_g = 124.9
SELECT SUM("gain") FROM "table_name_27" WHERE "avg_g" = 124.9 AND "long" > 8