What is the total number of losses Jackson, T., who had more than 27 gain, an avg/g smaller than 55.9, and a long less than 34, had?
CREATE TABLE table_name_41 (
    loss VARCHAR,
    long VARCHAR,
    name VARCHAR,
    gain VARCHAR,
    avg_g VARCHAR
)
SELECT COUNT(loss) FROM table_name_41 WHERE gain > 27 AND avg_g < 55.9 AND name = "jackson, t." AND long < 34
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 number of losses Jackson, T., who had more than 27 gain, an avg/g smaller than 55.9, and a long less than 34, had? ### Input: CREATE TABLE table_name_41 (
    loss VARCHAR,
    long VARCHAR,
    name VARCHAR,
    gain VARCHAR,
    avg_g VARCHAR
) ### Response: SELECT COUNT(loss) FROM table_name_41 WHERE gain > 27 AND avg_g < 55.9 AND name = "jackson, t." AND long < 34