Which Total Goals have Total Apps of 42 (3), and League Goals smaller than 1?
CREATE TABLE table_name_10 (
    total_goals INTEGER,
    total_apps VARCHAR,
    league_goals VARCHAR
)
SELECT MAX(total_goals) FROM table_name_10 WHERE total_apps = "42 (3)" AND league_goals < 1
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 Total Goals have Total Apps of 42 (3), and League Goals smaller than 1? ### Input: CREATE TABLE table_name_10 (
    total_goals INTEGER,
    total_apps VARCHAR,
    league_goals VARCHAR
) ### Response: SELECT MAX(total_goals) FROM table_name_10 WHERE total_apps = "42 (3)" AND league_goals < 1