user: ### NOW ANSWER:
Question: Which Total Apps (sub) has 6 goals total?
Columns: ['Season', 'League Apps (sub)', 'League Goals', 'Cup Apps (sub)', 'Cup Goals', 'Total Apps (Sub)', 'Total Goals']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1986–87', '– (-)', '–', '– (1)', '–', '– (1)', '–']
SQL:

assistant: SELECT "Total Apps (Sub)" FROM "Table" WHERE "Total Goals" = '6';