Table: election_2009_ns
Columns: polling_firm
dates
prog_cons
new_democratic
liberal

Question: What percentage of people polled aligned with the Liberal party according to the August 2008 poll that reported 36% aligning with New Democratic party?
SQL: SELECT "liberal" FROM election_2009_ns WHERE "new_democratic" = '36%' AND "dates" = 'august 2008'

Question: According to the August 2007 poll by the Corporate Research Associates that reported 32% Prog. Cons., what percentage aligned with the Liberal party?
SQL: SELECT "liberal" FROM election_2009_ns WHERE "polling_firm" = 'corporate research associates' AND "prog_cons" = '32%' AND "dates" = 'august 2007'

Question: Which firm conducted a poll in August 2006?
SQL: SELECT "polling_firm" FROM election_2009_ns WHERE "dates" = 'august 2006'

Question: According to the February 2009 poll by the Corporate Research Associates that reported 31% Liberal., what percentage aligned with the Prog. Cons. party?
SQL: SELECT "prog_cons" FROM election_2009_ns WHERE "polling_firm" = 'corporate research associates' AND "liberal" = '31%' AND "dates" = 'february 2009'

Question: According to the August 2008 poll that reported 36% New Demcratic, what percentage aligned with the Liberal party?
SQL: SELECT "liberal" FROM election_2009_ns WHERE "new_democratic" = '36%' AND "dates" = 'august 2008'