What's the total losses for the vancouver burrards in the 1947 season with fewer than 24 games?
CREATE TABLE table_name_8 (
    losses VARCHAR,
    games VARCHAR,
    team_name VARCHAR,
    season VARCHAR
)
SELECT COUNT(losses) FROM table_name_8 WHERE team_name = "vancouver burrards" AND season = "1947" AND games < 24
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What's the total losses for the vancouver burrards in the 1947 season with fewer than 24 games? ### Input: CREATE TABLE table_name_8 (
    losses VARCHAR,
    games VARCHAR,
    team_name VARCHAR,
    season VARCHAR
) ### Response: SELECT COUNT(losses) FROM table_name_8 WHERE team_name = "vancouver burrards" AND season = "1947" AND games < 24