Table schema:
CREATE TABLE table_name_8 (losses VARCHAR, games VARCHAR, team_name VARCHAR, season VARCHAR)

Question: What's the total losses for the vancouver burrards in the 1947 season with fewer than 24 games?
SQL: SELECT COUNT(losses) FROM table_name_8 WHERE team_name = "vancouver burrards" AND season = "1947" AND games < 24