user: ### NOW ANSWER:
Question: I want to know the sum of fa cup goals for david mirfin and total goals less than 1
Columns: ['Squad No.', 'Name', 'Position', 'League Apps', 'League Goals', 'FA Cup Apps', 'FA Cup Goals', 'League Cup Apps', 'League Cup Goals', 'FLT Apps', 'FLT Goals', 'Total Apps', 'Total Goals']
Types: ['real', 'text', 'text', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real']
Sample row: [2.0, 'Andy Holdsworth', 'DF', '43 (1)', 3.0, '5', 0.0, '0', 0.0, '1', 0.0, '49 (1)', 3.0]
SQL:

assistant: SELECT SUM("FA Cup Goals") FROM "Table" WHERE "Name" = 'david mirfin' AND "Total Goals" < 1.0;