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

How much Loss has a Gain smaller than 1571, and a Long smaller than 47, and an Avg/G of 36.4?
SELECT COUNT(loss) FROM table_name_27 WHERE gain < 1571 AND long < 47 AND avg_g = 36.4
SELECT COUNT("loss") FROM "table_name_27" WHERE "avg_g" = 36.4 AND "gain" < 1571 AND "long" < 47