user: ### NOW ANSWER:
Question: B.P. of 0, and a Pts Agst smaller than 247 has how many total number of played?
Columns: ['Position', 'Club', 'Played', 'Drawn', 'Lost', 'Pts For', 'Pts Agst', 'B.P.', 'Points']
Types: ['real', 'text', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1.0, 'Castleford Tigers', 18.0, 0.0, 1.0, 860.0, 247.0, 0.0, 51.0]
SQL:

assistant: SELECT COUNT("Played") FROM "Table" WHERE "B.P." = 0.0 AND "Pts Agst" < 247.0;