Which Record has a Result of win, and a Streak of won 1, and a Game of 47?
CREATE TABLE table_name_47 (
    record VARCHAR,
    game VARCHAR,
    result VARCHAR,
    streak VARCHAR
)
SELECT record FROM table_name_47 WHERE result = "win" AND streak = "won 1" AND game = 47
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: Which Record has a Result of win, and a Streak of won 1, and a Game of 47? ### Input: CREATE TABLE table_name_47 (
    record VARCHAR,
    game VARCHAR,
    result VARCHAR,
    streak VARCHAR
) ### Response: SELECT record FROM table_name_47 WHERE result = "win" AND streak = "won 1" AND game = 47