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

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'