CREATE TABLE table_40822 ("Season" CLOB, "League Apps  ( sub ) " CLOB, "League Goals" CLOB, "Cup Apps  ( sub ) " CLOB, "Cup Goals" CLOB, "Total Apps  ( Sub ) " CLOB, "Total Goals" CLOB)

Which Total Apps (sub) has 6 goals total?
SELECT "Total Apps (Sub)" FROM table_40822 WHERE "Total Goals" = '6'
SELECT "Total Apps (Sub)" FROM "table_40822" WHERE "Total Goals" = '6'