CREATE TABLE table_name_42 (polling_firm VARCHAR2, dates VARCHAR2)

Which firm conducted a poll in August 2006?
SELECT polling_firm FROM table_name_42 WHERE dates = "august 2006"
SELECT "polling_firm" FROM "table_name_42" WHERE "august 2006" = "dates"