What is the total for 34 matches with 111 rides, but no more than 15 bonus points?
CREATE TABLE table_name_29 (
    total_points INTEGER,
    bonus_pts VARCHAR,
    matches VARCHAR,
    rides VARCHAR
)
SELECT AVG(total_points) FROM table_name_29 WHERE matches = 34 AND rides = 111 AND bonus_pts > 15
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 total for 34 matches with 111 rides, but no more than 15 bonus points? ### Input: CREATE TABLE table_name_29 (
    total_points INTEGER,
    bonus_pts VARCHAR,
    matches VARCHAR,
    rides VARCHAR
) ### Response: SELECT AVG(total_points) FROM table_name_29 WHERE matches = 34 AND rides = 111 AND bonus_pts > 15