what is the sum of games played when the losses is less than 7, the wins is 6 and the goals for is more than 76?
CREATE TABLE table_name_31 (
    games_played INTEGER,
    goals_for VARCHAR,
    losses VARCHAR,
    wins VARCHAR
)
SELECT SUM(games_played) FROM table_name_31 WHERE losses < 7 AND wins = 6 AND goals_for > 76
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 is the sum of games played when the losses is less than 7, the wins is 6 and the goals for is more than 76? ### Input: CREATE TABLE table_name_31 (
    games_played INTEGER,
    goals_for VARCHAR,
    losses VARCHAR,
    wins VARCHAR
) ### Response: SELECT SUM(games_played) FROM table_name_31 WHERE losses < 7 AND wins = 6 AND goals_for > 76