user: Question: What is the toal rec with more than 27 and averages less than 10.8 and TDs more than 6?
Columns: ['Player', 'Rec.', 'Yards', 'Avg.', "TD's", 'Long']
Types: ['text', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Cornelius Bonner', 102.0, 1436.0, 14.1, 29.0, 49.0]
SQL:

assistant: SELECT COUNT("Long") FROM "Table" WHERE "Rec." > 27.0 AND "Avg." < 10.8 AND "TD's" > 6.0;