user: ### NOW ANSWER:
Question: When the Long is 42, what is the average TD's?
Columns: ['Player', 'Rec.', 'Yards', 'Avg.', "TD's", 'Long']
Types: ['text', 'real', 'text', 'text', 'real', 'text']
Sample row: ['Charles Frederick', 115.0, '1385', '12', 27.0, '42']
SQL:

assistant: SELECT AVG("TD's") FROM "Table" WHERE "Long" = '42';