Que Byes têm perdas maiores que 0, e um Contra maior que 3049?
CREATE TABLE table_name_7 (byes INTEGER, losses VARCHAR, against VARCHAR)
SELECT AVG(byes) FROM table_name_7 WHERE losses > 0 AND against > 3049