What is the sum of the interview scores from North Dakota that have averages less than 8.697, evening gown scores less than 8.73, and swimsuit scores greater than 8.41?
CREATE TABLE table_name_4 (
    interview INTEGER,
    swimsuit VARCHAR,
    state VARCHAR,
    average VARCHAR,
    evening_gown VARCHAR
)
SELECT SUM(interview) FROM table_name_4 WHERE average < 8.697 AND evening_gown < 8.73 AND state = "north dakota" AND swimsuit > 8.41
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 the interview scores from North Dakota that have averages less than 8.697, evening gown scores less than 8.73, and swimsuit scores greater than 8.41? ### Input: CREATE TABLE table_name_4 (
    interview INTEGER,
    swimsuit VARCHAR,
    state VARCHAR,
    average VARCHAR,
    evening_gown VARCHAR
) ### Response: SELECT SUM(interview) FROM table_name_4 WHERE average < 8.697 AND evening_gown < 8.73 AND state = "north dakota" AND swimsuit > 8.41