How many apps have 28 goals, and a Total smaller than 191?
CREATE TABLE table_name_42 (
    apps INTEGER,
    goals VARCHAR,
    total VARCHAR
)
SELECT SUM(apps) FROM table_name_42 WHERE goals = "28" AND total < 191
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: How many apps have 28 goals, and a Total smaller than 191? ### Input: CREATE TABLE table_name_42 (
    apps INTEGER,
    goals VARCHAR,
    total VARCHAR
) ### Response: SELECT SUM(apps) FROM table_name_42 WHERE goals = "28" AND total < 191