Qual é a média dos objetivos finais se o total de objetivos for inferior a 1?
CREATE TABLE table_name_40 (finals_goals INTEGER, total_goals INTEGER)
SELECT AVG(finals_goals) FROM table_name_40 WHERE total_goals < 1