What is the total PL G of player pennant, who has less than 7 CL G, less than 7 CL apps, and a FA YC of 0?
CREATE TABLE table_name_74 (
    pl_g VARCHAR,
    player VARCHAR,
    fa_yc VARCHAR,
    cl_g VARCHAR,
    cl_apps VARCHAR
)
SELECT COUNT(pl_g) FROM table_name_74 WHERE cl_g < 7 AND cl_apps < 7 AND fa_yc = 0 AND player = "pennant"
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 PL G of player pennant, who has less than 7 CL G, less than 7 CL apps, and a FA YC of 0? ### Input: CREATE TABLE table_name_74 (
    pl_g VARCHAR,
    player VARCHAR,
    fa_yc VARCHAR,
    cl_g VARCHAR,
    cl_apps VARCHAR
) ### Response: SELECT COUNT(pl_g) FROM table_name_74 WHERE cl_g < 7 AND cl_apps < 7 AND fa_yc = 0 AND player = "pennant"