user: ### NOW ANSWER:
Question: What is the number of league goals when Bill Dearden was the scorer and there was 0 league cup goals?
Columns: ['Scorer', 'Club', 'League goals', 'FA Cup goals', 'League Cup goals', 'Total']
Types: ['text', 'text', 'text', 'text', 'text', 'real']
Sample row: ['Malcolm Macdonald', 'Luton Town', '24', '4', '2', 30.0]
SQL:

assistant: SELECT "League goals" FROM "Table" WHERE "League Cup goals" = '0' AND "Scorer" = 'Bill Dearden';