CREATE TABLE table_name_19 (losses NUMBER, games_played VARCHAR2, goals_for VARCHAR2)

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