Table schema:
CREATE TABLE table_name_19 (losses INTEGER, games_played VARCHAR, goals_for VARCHAR)

Question: for goals less than 48 and 8 games played what is the count of losses?
SQL: SELECT MAX(losses) FROM table_name_19 WHERE games_played = 8 AND goals_for < 48