CREATE TABLE table_name_74 (pl_g VARCHAR2, player VARCHAR2, fa_yc VARCHAR2, cl_g VARCHAR2, cl_apps VARCHAR2)

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?
SELECT COUNT(pl_g) FROM table_name_74 WHERE cl_g < 7 AND cl_apps < 7 AND fa_yc = 0 AND player = "pennant"
SELECT COUNT("pl_g") FROM "table_name_74" WHERE "cl_apps" < 7 AND "cl_g" < 7 AND "fa_yc" = 0 AND "pennant" = "player"