Quais são os gols com empates menores que 6 e perdas menores que 7?
CREATE TABLE table_name_9 (goals_for INTEGER, draws VARCHAR, losses VARCHAR)
SELECT AVG(goals_for) FROM table_name_9 WHERE draws < 6 AND losses < 7