CREATE TABLE table_78206 ("Date ( s )  conducted" CLOB, "Polling organisation/client" CLOB, "Cons" CLOB, "Plaid Cymru" CLOB, "Lib Dem" CLOB, "Others" CLOB, "Lead" CLOB)

I want the plaid cymru for 4 may 2011
SELECT "Plaid Cymru" FROM table_78206 WHERE "Date(s) conducted" = '4 may 2011'
SELECT "Plaid Cymru" FROM "table_78206" WHERE "Date(s) conducted" = '4 may 2011'