SCHEMA:
CREATE TABLE table_name_19 (losses INTEGER, games_played VARCHAR, goals_for VARCHAR)
USER:
for goals less than 48 and 8 games played what is the count of losses?

QUERY:
SELECT MAX(losses) FROM table_name_19 WHERE games_played = 8 AND goals_for < 48