CREATE TABLE table_name_47 (avg_g VARCHAR2, att_cmp_int VARCHAR2)

What was the aveg/g for the qb with the Att-Cmp-Int of 117 215 6?
SELECT COUNT(avg_g) FROM table_name_47 WHERE att_cmp_int = "117–215–6"
SELECT COUNT("avg_g") FROM "table_name_47" WHERE "117–215–6" = "att_cmp_int"