CREATE TABLE table_name_62 (avg_g VARCHAR, att_cmp_int VARCHAR, effic VARCHAR)

Avg/G that has a Att-Cmp-Int of 1 1 0, and an Effic larger than 394 is what total?
SELECT COUNT(avg_g) FROM table_name_62 WHERE att_cmp_int = "1–1–0" AND effic > 394
SELECT COUNT("avg_g") FROM "table_name_62" WHERE "1–1–0" = "att_cmp_int" AND "effic" > 394