user: ### NOW ANSWER:
Question: Which firm conducted a poll in August 2006?
Columns: ['Polling firm', 'Dates', 'Prog. Cons.', 'New Democratic', 'Liberal']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['2009 Election Results', 'June 9, 2009', '24.54%', '45.24%', '27.20%']
SQL:

assistant: SELECT "Polling firm" FROM "Table" WHERE "Dates" = 'August 2006';